Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problem Importing Data Using DTS / SQL Server
It sounds so, with SQL Server. when I ran DTS it completed first step i.e to created the table at destination server, successfully. But On the second step [Copy Data from SourceTable TO Destination Table ] gave [Error Occurred]. And yes, I converted the type in DTS for I don't have access to... -
Problem Importing Data Using DTS / SQL Server
I tried to import data following above instructions, but still facing the same error. I even tried after converting all data types to variant, but still did not work. All suggestions are well come. Thanks -
Problem Importing Data Using DTS / SQL Server
I have to import data from a database system [ called Unify DB System ]. I have an ODBC driver for Unify through which I can access it when I connect from Access 97 or VB using ADO and data is transformed successfully. But when I try to connect to this database system from SQL Server and write...
