DTS

I used the DTS to transfer data to a new server, I received an error message "Bulk copiy failure", but in checking my destination datanbase data was indeed transfered.
Is it safe to assume that there are no errors, or what is the source of the error?
Thanks
You can receive this error if there are blank lines in the end of the
file you are transferring and the destination has non-nullable columns.
You should try to eliminate blank rows from the source file, use an
ActiveX task to skip rows that are blank or bring the data into a
holding table with all nullable columns then copy the data from there to
your real tables.
Regards,
William D. Bartholomew
http://blog.bartholomew.id.au/
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!