DTS error

[DrewConn]

Has anyone run into the following error regarding DTS or importing?

I am importing a series of identical Access table into SQL server 7.0 Most of the tabes come in fine but some are giving me the following eror:

Error at destination for row number 136605...Invalid character value for cast specification.

I have reviewed all of the data in that record and see no anomolies.

Any ideas?

Thanks.

 

[Sheffield]

I have had the error a number of times. Check to see the specifics of the DTS import error. It should specifically list those columns where the problem exists.

One thought worth noting: SQL Server has datatypes that differ from MS-Access. Check out each column being imported and transform a questionable column to the corresponding SQL Server datatype within the DTS Wizard.

Another thing....if you are attempting to import a table into an already existing SQL Server table, you must make certain that you transform accordingly for an Identity Seed column or columns that don't exist in your Access DB.

Hope that helps