Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 2:41 PM
Points: 328, Visits: 738
When Using Configurations Do You Have To Set the ConnectionManagers Delay Validation To True?
Post #1580711
Posted Sunday, June 15, 2014 9:43 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:03 PM
Points: 2,967, Visits: 2,569
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
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 3:13 PM
Points: 1,795, Visits: 4,679
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:51 PM
Points: 13,639, Visits: 10,534
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 LessThanDot.

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

Add to briefcase

Permissions Expand / Collapse