Posted by deepakgeorge on 04/03/07 14:39

We are trying to migrate databases and DTS from SQL Server 2000 to
2005.

A BULK insert with in a DTS is failing showing the error.
Bulk load data conversion error (type mismatch or invalid character
for the specified codepage)

BULK insert is reading a text file from the local system where the
dates are in the format mm/dd/yyyy.

When I change the date format to dd/mm/yyyy , it is working which is
not practical as there are many files with many records.

When we create a new user on the server, and when the new user
executes the DTS everything works fine for the first time but fails on
the second try and later.

We have SQL server 2005 installed with Service Pack2.

The DTS on SQL Server 2005 also works fine when we try to do the BULK
insert to the databases on SQL Server 2000.

Has anyone come across this problem and any solutions will be
appreciated

Regards,
Deepak

[Back to original message]