SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
dndaughtery
dndaughtery
SSCertifiable
SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)

Group: General Forum Members
Points: 6508 Visits: 1098
When Using Configurations Do You Have To Set the ConnectionManagers Delay Validation To True?
happycat59
happycat59
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17627 Visits: 3294
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
Eirikur Eiriksson
SSC Guru
SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)

Group: General Forum Members
Points: 93433 Visits: 20644
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.
Cool
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (144K reputation)SSC Guru (144K reputation)SSC Guru (144K reputation)SSC Guru (144K reputation)SSC Guru (144K reputation)SSC Guru (144K reputation)SSC Guru (144K reputation)SSC Guru (144K reputation)

Group: General Forum Members
Points: 144884 Visits: 13349
dndaughtery (6/13/2014)
When Using Configurations Do You Have To Set the ConnectionManagers Delay Validation To True?


No. Configurations are loaded before validation.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search