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)
 Bulk Insert Problem

Author  Topic 

rkpamidi
Starting Member

5 Posts

Posted - 2001-07-05 : 09:05:08
we have a sqlserver standard edition on an NT .we want to transfer the database with data to another sqlserver(desktop edition) remotely located.
we have used DTS to export the data to a file
with comma as column delimiter and '|' as row delimiter(table by table).But when we tried to Bulk Insert the data to the other remote sqlserver it is failing with errors
but we are able to insert data into tables
having only INT datatype.
CAn anyone suggest what is the correct procedure in such situations and solution to the above problem?

   

- Advertisement -