blogs.conchango.com

welcome to the conchango blogging site
Welcome to blogs.conchango.com Sign in | Join | Help
in Search

SSIS Junkie

Conchango are busy and need talented consultants in and around London. Interested? Email me or send me a message

SSIS: DTS Connections and SSIS Connection Managers

A post appeared on the SSIS forum today in which the poster was getting slightly confused about the use of SSIS Connection Managers and how they differ from DTS Connections so I thought it would be a good idea to illustrate the differences here to hopefully save anyone else from having the same headaches.

A problem with DTS Connections was that if all your tasks used the same Connection object then everything happened agains the same physical connection. Not a good situation as operations against the connection object effectively get queued up. This problem is alluded to at the bottom of this article.

This is not the case with SSIS Connection Managers. Instead, Connection Managers maintain a pool of connections. Each task that utilises the Connection Manager will get its own connection to the data source.

Note that if you want to you can make SSIS Connection Managers behave like DTS Connections by setting RetainSameConnection=TRUE. There is actually a use for this as exhibited here: http://blogs.conchango.com/jamiethomson/archive/2005/08/20/2048.aspx

-Jamie

 

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Professional Association for SQL Server (PASS) SIG said:

April 3, 2006 00:09
 

Amir Saberi said:

WE have an application that uses DTS.  We tried running it in Vista.  And DTS is opening a second connection when it starts the data pump step!

How can I keep it from doing this?

March 28, 2008 07:33

Leave a Comment

(required) 
(optional)
(required) 
Submit

This Blog

Syndication

News

Powered by Community Server (Personal Edition), by Telligent Systems