We have a custom connection manager in an SSIS 2005 package. We're able to click on "New Connection" in the Connection Manager section of the data flow task, and see the connection manager in the list. But how do we leverage this new custom connection manager
as a source? The DataReader source doesn't seem to be an option anymore. We can't seem to create a new data flow task using this new connection manager as a source.
Ironically, the package runs as is after conversion from 2005 to 2008. It's just that we can't change it or add new data flow tasks using this new connection manager as a source.
View Complete Post