I have a custom data connection that we used in SQL 2005 to connect to a non-standard source to pull data. We are in the process of upgrading to SQL 2008 R2 and I am running
into an issue that hopefully someone can help me with.
I have upgraded my custom connection code for SQL 2008 R2.
I can set up a connection using the custom code inside of an SSIS package.
However, when I go to a data flow task and try to select a connection for a data source object, OLEDB or ADO.Net data sources, my connection is not available.
If I select new on the connection option, my connection type is not available.
To get around this in SQL 2005 I used the data reader source.
The data reader source is not available in SQL 2008 R2.
So I am stuck.
My custom connection is implemented as an IDBConnection.
View Complete Post