<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Kenneth Fisher
»
Dynamic connections in SSIS
22 posts, Page 1 of 3
1
2
3
»
»»
Dynamic connections in SSIS
Rate Topic
Display Mode
Topic Options
Author
Message
Kenneth.Fisher
Kenneth.Fisher
Posted Sunday, January 27, 2008 10:19 AM
Hall of Fame
Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:31 AM
Points: 3,367,
Visits: 1,563
Comments posted to this topic are about the item
Dynamic connections in SSIS
Kenneth Fisher
I strive to live in a world where a chicken can cross the road without being questioned about its motives.
--------------------------------------------------------------------------------
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Link to my Blog Post -->
www.SQLStudies.com
Post #448056
Gordon Radley
Gordon Radley
Posted Monday, January 28, 2008 6:04 AM
Say Hey Kid
Group: General Forum Members
Last Login: Wednesday, November 28, 2012 8:34 AM
Points: 672,
Visits: 186
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."
Post #448252
craigpessano
craigpessano
Posted Monday, January 28, 2008 6:19 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: 2 days ago @ 2:51 PM
Points: 4,003,
Visits: 1,485
I'm wondering the same thing as Gordon. As is often the case, it seems that there are multiple ways of accomplishing the goal.
Quote from SQL Server 2005 Books Online:
Connection Manager How-to Topics (SSIS)
The properties of connection managers such as the connection string must frequently be updated at run time. To learn more about dynamically updating properties, see Package Configurations and Using Property Expressions in Packages.
Post #448258
Jim Howell
Jim Howell
Posted Monday, January 28, 2008 6:47 AM
SSC-Addicted
Group: General Forum Members
Last Login: Monday, January 14, 2013 10:34 PM
Points: 428,
Visits: 334
I would have to agree that No. 3 is correct also.
Post #448274
Kenneth.Fisher
Kenneth.Fisher
Posted Monday, January 28, 2008 7:19 AM
Hall of Fame
Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:31 AM
Points: 3,367,
Visits: 1,563
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 Fisher
I strive to live in a world where a chicken can cross the road without being questioned about its motives.
--------------------------------------------------------------------------------
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Link to my Blog Post -->
www.SQLStudies.com
Post #448290
Jeff Deluca
Jeff Deluca
Posted Monday, January 28, 2008 7:42 AM
SSC-Addicted
Group: General Forum Members
Last Login: Tuesday, May 31, 2011 2:32 PM
Points: 491,
Visits: 221
I'm not sure if this helps anyone but I found this article.
I've never done it this way myself.
http://msdn2.microsoft.com/en-us/library/ms136093.aspx
Post #448308
Kenneth.Fisher
Kenneth.Fisher
Posted Monday, January 28, 2008 7:55 AM
Hall of Fame
Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:31 AM
Points: 3,367,
Visits: 1,563
Also just to point it out, part of what I was trying to get at was that you could create a loop in your package to run through a list of servers, files, etc and inside the loop put a script object that changes your connection string. Then create any other object that uses that connection.
I've used it to run the same script on a series of servers and to import data from a series of similar files. In one instance I used it it to let me test a connection where I had just changed the password to a random string.
Kenneth Fisher
I strive to live in a world where a chicken can cross the road without being questioned about its motives.
--------------------------------------------------------------------------------
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Link to my Blog Post -->
www.SQLStudies.com
Post #448323
Gordon Radley
Gordon Radley
Posted Monday, January 28, 2008 8:02 AM
Say Hey Kid
Group: General Forum Members
Last Login: Wednesday, November 28, 2012 8:34 AM
Points: 672,
Visits: 186
Fair Enough!!
Obviously my interpretation of the question was a bit off..
Thank you!
Post #448330
viacoboni
viacoboni
Posted Monday, January 28, 2008 10:40 AM
Say Hey Kid
Group: General Forum Members
Last Login: Friday, May 03, 2013 11:50 AM
Points: 712,
Visits: 410
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
Post #448466
Kenneth.Fisher
Kenneth.Fisher
Posted Monday, January 28, 2008 12:12 PM
Hall of Fame
Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:31 AM
Points: 3,367,
Visits: 1,563
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 Fisher
I strive to live in a world where a chicken can cross the road without being questioned about its motives.
--------------------------------------------------------------------------------
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Link to my Blog Post -->
www.SQLStudies.com
Post #448514
« Prev Topic
|
Next Topic »
22 posts, Page 1 of 3
1
2
3
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
