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. Steve Coleman

A custom connection manager will always need a custom consumer, be it a task, log provider, source etc The Data Reader source would never have been able to use a custom connection manager. The data reader source uses (ADO) .NET data providers. The data reader source is pretty much the same as the ADO.NET Source in 2008. Perhaps you had a custom ADO.NET provider rather than a connection manager? If so just install it on your 2008 machine and use it as before, albeit with the "renamed" source.http://www.sqlis.com | http://www.konesans.com