I have a simple SSIS package with a single task (data flow task). The data flow task has 2 connection managers: OLEDB connection manager for the source database (not SQL but has a working UniOLEDB data provider) OLEDB connection manager for the target SQL server database I then have 5 sets of OLE DB Source / OLE DB Destination tasks to copy data from the Universe database into the SQL database. I execute the package successfully by clicking on the START button, waiting for the tasks to complete, and then stopping. There are no errors and the destination SQL tables have the expected results. After running the package we can see (still) open connections in the source database. We have to give a LOGOUT command (similar to KILL command in SQL) to get rid of those connections. How do I close the connection to the source database? Is there a way to explicitly close a connection? Thank you, Omid

Hi Omid, you can probably issue the LOGOUT command from an Execute SQL Task, or a script task. I am not familiar with the UniOLEDB but it might have an option to autoclose a connection, why not to explore this avenue?Arthur My Blog

Not a real solution, but if you set the property RetainSameConnection to TRUE on the connection manager, you have only one connection to be worried about.