Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  SQL Server ODBC Source

Author  Topic  elireu Starting Member 1 Post Posted - 2008-05-12 : 15:08:33 Hi, I ran into an issue in SQL Server 2005 that you might be able help me: I created a new project in Visual Studio 2005. My project needs to connect to an ODBC source, extract data from a table and insert it into a table in SQL Server. I created the Data Flow Task in the Control Flow and created a new connection: .Net Providers\Odbc Data Provider in the Connection Manager and I used my data source name that I defined in the ODBC on the local machine. I also successfully tested the connection. However, when I create a DataReader Source in the Data Flow, there is no connection available in the Connection Manager tab. Instead, there is an error message: “Not all connection managers have been set. Set all connection managers” I’ve been searching the Internet for days and couldn’t find a solution for that. Please HELP. Thank you Eli