Delay Validation and forcing a Design Time Validation
Quick question, I can work in Offline mode when designing and/or set my package to delay validation. What if I want to force a validation to ensure everything is in order at some point in time? Is that possible somehow?
September 21st, 2009 9:04pm

yes it is almost on every object specially the pacakge it self you can see in the property DELAY VALIDATION just set it to FALSE Sincerely SH -- Please kindly dont forget to mark the post(s) that answered your question and/or vote for the post(s)
Free Windows Admin Tool Kit Click here and download it now
September 21st, 2009 9:06pm

one question why do yu want to do that , can you give us some example , thanksSincerely SH -- Please kindly dont forget to mark the post(s) that answered your question and/or vote for the post(s)
September 21st, 2009 9:11pm

Generally I am coming in to make changes due to underlying schema changes in a DB. If I know of the validation issues, why do I need to be made aware of them before I do the work. I just want to make sure everythign validates after I am done making the changes.
Free Windows Admin Tool Kit Click here and download it now
September 21st, 2009 9:17pm

so did you get your answer?Sincerely SH -- Please kindly dont forget to mark the post(s) that answered your question and/or vote for the post(s)
September 21st, 2009 9:22pm

No, I am looking for a way to force a validation. If I have set my package to DelayValidation = True so that I do not have to wait through a startup event, and I clater want to validate, how do I do that?
Free Windows Admin Tool Kit Click here and download it now
September 21st, 2009 9:26pm

No, I am looking for a way to force a validation. Set Delay Validation to false.Nitesh Rai- Please mark the post as answered if it answers your question
September 21st, 2009 9:28pm

No, I am looking for a way to force a validation. Set Delay Validation to false. Nitesh Rai- Please mark the post as answered if it answers your question This does not force a validation at that point in time unless I am missing something. I would have to close my Project and re-open it which is what I want to avoid.
Free Windows Admin Tool Kit Click here and download it now
September 21st, 2009 9:30pm

fine i got your pointmake a variable in SSIS make a (SCOPE = Pacakge) e.g uVar_glbDelayValidationin your property of any object or maybe in your case for the Pacakge it self ....Select Property ---> Expressions ----> click on the 3 dots , A small window opens ---> Property = DelayValidation AND Expression = @[User::uVar_glbDelayValidation]now when configuring your packge set the variableuVar_glbDelayValidation in the config file or table , then you can change itbefore calling the package.Sincerely SH -- Please kindly dont forget to mark the post(s) that answered your question and/or vote for the post(s)
September 21st, 2009 9:35pm

Hi Marc,Sounds like for certain reason, you want to bypass external connection by setting working offlineor bypassing external metadata check bysettingdelaying validation. Manwhile you still want to Validate the whole package explicitly at some pointin time you have chosen. Is my understanding true?May I know the reason you set work offline/delay valiation instead of using a default setting, Is it because you have a slow connectionor somehowmetadata validation becomes abig overhead etc? Understand the real user cases can help us design a better product in the future.Thanks,Jia
Free Windows Admin Tool Kit Click here and download it now
September 23rd, 2009 3:04am

You can also use dtexec (in 2008) to validate the package without executing it. Cheers, JamesJames Beresford @ http://www.bimonkey.com SSIS / MSBI Consultant in Sydney, Australia
September 23rd, 2009 4:06am

I realize that this thread is somewhat dated, but thought I would add that another reason to delay validation is for a case I run into regularly. When passwords are forced to expire regularly, the embedded credentials need to be changed. If the password is changed for the account before the package is opened, the datasource gets multiple hits with an invalid password when validation occurs...often locking out the account.
Free Windows Admin Tool Kit Click here and download it now
February 1st, 2011 1:46pm

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

Other recent topics Other recent topics