August 3, 2016 at 3:20 am
Hi there,
I have to load data from a CassandraDB.
I am using the datastax odbc-driver in SSIS (2014) and I have following situation
The package connects to the database, loads the data, does everything else in the ssis-package but the sql server agent won't finish the package.
In debug-mode it "seems" to work fine, but you see that the DtsDebugHost.exe is still running after you finished the debug mode.
I tried a few angles to solve this and what I can see in the cassandra-monitoring the connection remains open.
I ended in writing an script source where I acquire and close the connection and this works fine.
The connection is closed properly and in Debug and Agent it works fine.
I didn't test yet, if this script source is slower or faster, however it much harder to maintain.
My question would be:
Can I somehow force the odbc-source to close the connection properly or
if it is not possible to create a script-task that would close the connection to the (ODBC)-cassandra-source explicitly at the end of the package, so I can use the build-in odbc data source?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply