viacoboni (1/28/2008)
Gordon Radley (1/28/2008)
Fair Enough!!Obviously my interpretation of the question was a bit off..
Thank you!
Gordon,
Based on the most popular "incorrect" answer, I'd say it was more than just you interpreting the question a different way. If the question author meant "multiple servers connecting to the same OLEDB connection once the package has started", it should have been worded so. Otherwise, package configurations are the natural way to change OLEDB connections at runtime.
Vince
Vince,
You are absolutly correct. Package Configurations are the natural way to change OLEDB connections at runtime. However the question was
In SQL 2005 Integration Services can an OLE DB connection be dynamicaly changed during execution.
I appologize if it was confusing. I did my best to word it clearly without giving away the answer completly.
I spent quite a bit of time making sure I had the definition of "Run Time" vs "Execution Time" correct.
Kenneth
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]