Gordon Radley (1/28/2008)
I realze option 4 is correct if you use the DTS object model to execute the task, but I use package configurations all the time to change connection values at run time.Why is option 3 not also a correct answer here?
"Yes - In SSIS connections can be dynamically updated during execution using package configurations."
The question wasn't can you change them at run time .. which is what the package configurations are for .. but during execution. Ie can you use the same connection to hit multiple servers during the same execution of the package.
I could certainly be wrong but my understanding of package configurations is that they only happen when you initially run the package.
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]