How does one drop / close a connection from inside a SSIS .NET script task?

I have a long running package (i.e. 12-18 hours) that extracts data from an
Oracle Datawarehouse, and populates a data mart in SQL Server 2005. The
Connection manager properties for the oracle connection has
RetainSameConnection = True for the processing that needs to take place on
Oracle. I need to drop / close the connection to Oracle after the data has
downloaded and not wait for the processing on SQL Server to complete. I
have tried a couple different ways to do this, but without luck.

Hello vnapoli,

If you have RetainSameConnection to true isn't that because you want the
same connection to span n processes so maybe you are creating and reusing
#tables or you want to maintain a native txn across processes?

What you want here it would seem is to not do that and just have each instantiation
of a Connection do its own thing.

What happens if you set the property to false?



--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]