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.
Author |
Topic |
Togaspoon
Starting Member
42 Posts |
Posted - 2008-02-06 : 17:15:34
|
I'm trying to create a new package and keep getting different errors. The package uses the same .NET ODBC provider as another package.I can test the connection fine.When I add a DataReader Source and select my connection I get the following warning:Not all connection managers have been set. Set all connection managers.If I click the refresh button I get this warning message:Error at Data Flow Task [DataReader Source [6338]]: The runtime connection manager with the ID "" cannot be found. Verify that the connection manager collection has a connection manager with that ID.All my collections have ID's and they are all read only.If I ignore those warning I can enter my SQL command and go to the column mappings tab and see all the columns I selected but I then see several warnings all saying the same thing.Driver does not support this functionI'm not able to close the Advanced Editor at this point.Any ideas? |
|
Togaspoon
Starting Member
42 Posts |
Posted - 2008-02-06 : 17:19:17
|
If I delete the connection I still see the errors. It's like there is a partial connection out there that I can see but is hosing up my project. |
|
|
Togaspoon
Starting Member
42 Posts |
Posted - 2008-02-06 : 17:29:46
|
OKForget those 1st two errors that was just me being stupid, once I assigned my DataReader to the connection manager they went away.Now I just need to deal with this error:Error at Data Flow Task [DataReader Source [6825]]: System.Data.Odbc.OdbcException: ERROR [IM001][Microsoft][ODBC Driver Manager] Driver does not support this function (x 20+)I've used this driver with other packages. |
|
|
|
|
|