Text to SQL Server Datapump -
08-25-2005
, 08:12 AM
I have a working txt to sql server datapump working in DTS in SQL Server
2000. Using the June CTP, I have been able to establish a project that
defines a flat file input, a copy column transformation, and a SQL server
output. I cannot get beyond the message that says:
Error 1 Validation error. Data Flow Task: SQL Server Destination [210]: A
connection manager has not been assigned to the runtime connection
"OleDbConnection" (211). Package.dtsx 0 0
***
I've tried many things, one of which is trying to locate (211), above.
Any help is gratefully appreciated. George.
--
George |