When Using Configurations in A Table Do You Have To Set the ConnectionManagers Delay Validation To True?

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

happycat59 One Orange Chip Points: 29389 More actions · Answer 1

dndaughtery (6/13/2014)
When Using Configurations Do You Have To Set the ConnectionManagers Delay Validation To True?

Normally, there is no need to set delay validation to true when using configuration.

You normally need to do this when, for example, you are using expressions for a connection manager.

Eirikur Eiriksson SSC Guru Points: 182916 More actions · Answer 2

dndaughtery (6/13/2014)
When Using Configurations Do You Have To Set the ConnectionManagers Delay Validation To True?

Doesn't make much difference at execution time, but often helps at design time, especially with more complex packages.

😎

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

dndaughtery (6/13/2014)
When Using Configurations Do You Have To Set the ConnectionManagers Delay Validation To True?

No. Configurations are loaded before validation.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP