Change Server to Pre-Validate against
I need a way to change the server the package pre-validates against, can this be done in the config or will it always look in the package for this value? The reason Im asking this is because once these packages are in either QA or Production they are always trying to per validate against Dev and sometimes they are failing due to connection issues, I would much rather have them just validate against the server they are running on.
May 18th, 2012 5:37pm

What items are validating in a way you don't like? Tasks? Connection Managers? Are you using package configurations? Talk to me now on
Free Windows Admin Tool Kit Click here and download it now
May 18th, 2012 8:06pm

Yes Im using package configurations, unfortunately SSIS pre-validates its meta data against the database listed in the package, then executes against config values. So I want a clean way to change it since Im not allowed to deploy out of TFS in my environment.
May 23rd, 2012 10:55am

Seems that you need to use the offline mode for the package. Set this setting up: http://www.google.ca/imgres?q=ssis+offline+mode&um=1&hl=en&safe=off&sa=N&noj=1&gbv=2&tbm=isch&tbnid=Ry875RNyrOXCXM:&imgrefurl=http://microsoft-ssis.blogspot.com/2011/11/long-validation-of-ssis-packages-in.html&docid=61_t4iitAN8vzM&imgurl=http://4.bp.blogspot.com/-5qIw5hM8jvw/TtFO0CC6t5I/AAAAAAAAAds/gSmErRkm0d0/s1600/validation05.jpg&w=443&h=410&ei=1Pu8T5PZGY-62gWJhpiUDw&zoom=1&iact=rc&dur=381&sig=117639262121657972501&page=1&tbnh=147&tbnw=159&start=0&ndsp=20&ved=1t:429,r:7,s:0,i:86&tx=82&ty=68&biw=1280&bih=839 this will stop validating before running.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
May 23rd, 2012 11:23am

In this article it says: There are two concerns/downsides for this solution: 1) You cant debug/run your package when you are in offline mode (of course, cant do anything about that). Does that mean I wont be able to run the package when in offline mode?
May 23rd, 2012 12:01pm

Yes. Offline mode is only applicable to a package loaded into BIDS/VSArthur My Blog
Free Windows Admin Tool Kit Click here and download it now
May 23rd, 2012 12:09pm

oh...so if i try to run this via an agent job...would it try to pre-validate?
May 23rd, 2012 5:31pm

SSIS will because it is now running outside BIDS. You need to deploy it with the correct config Jymbo.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
May 23rd, 2012 5:34pm

But it wont pre-validate against connections defined in the config...it pre-validates against the connections defined in the package file correct?
May 23rd, 2012 6:20pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics