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 Administration (2000)
 SQL 7 DTS Problem.....

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-10-16 : 18:45:00
Charlie writes "Heres the problem I'm having...

I created a DTS package in SQL 7 to transfer some tables from Access to a SQL7 server. Most of the tables copy ok, but a few of them give me the following error...

Error at Destination for Row number 1523

Invalid character value for cast specification

As a test I copied the table and deleted that row and a bunch of rows around it.. It still has the error.

Any ideas???"
   

- Advertisement -