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: Wednesday, November 26, 2014 8:25 AM
Points: 355, Visits: 803
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: Wednesday, November 26, 2014 5:22 PM
Points: 3,064, Visits: 2,676
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:43 AM
Points: 2,421, Visits: 6,738
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: Yesterday @ 8:55 AM
Points: 13,570, Visits: 11,383
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