Problem Importing Data Using DTS / SQL Server

[webb263]

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 DTS. The structure of the source database is copied successfully but I was never able to get data into SQL Server. Please suggest some solution. All sort of opinions are well come and thanks in advance.

 

[softwarescience]

Hello

I too have experienced this.
The problem I found was SQL rather strong data typing. This means that although DTS converts all the data types from your previous database to SQL, teh data within them does not match SQL expectations and so it fails.

I did a couple of things;
1) Import to Access and then import the Access DB to SQL
2) In DTS convert all numeric fields to float data type, all date fields to a variant data type etc

Hope this helps

 

[webb263]

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

 

[softwarescience]

That's not very helpfull of SQL-Server!!

What is the error it comes up with?

PS Did you convert the type in the Unify db or in DTS transformations area?

 

[webb263]

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 change the data type in UnifyDB.