Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

When Using Configurations in A Table Do You Have To Set the ConnectionManagers Delay Validation To True? Expand / Collapse
Author
Message
Posted Friday, June 13, 2014 12:56 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 10:09 AM
Points: 445, Visits: 1,030
When Using Configurations Do You Have To Set the ConnectionManagers Delay Validation To True?
Post #1580711
Posted Sunday, June 15, 2014 9:43 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, September 15, 2016 10:54 PM
Points: 3,500, Visits: 3,025
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.



Post #1580983
Posted Sunday, June 15, 2014 9:57 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:06 PM
Points: 5,955, Visits: 15,978
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.
Post #1580986
Posted Monday, June 16, 2014 12:17 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: 2 days ago @ 2:39 AM
Points: 15,371, Visits: 13,116
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?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1580998
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse