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
 Import/Export (DTS) and Replication (2000)
 Bulk Insert - not inserting data

Author  Topic 

chsundar
Starting Member

4 Posts

Posted - 2005-09-08 : 09:59:19
Hi All,

We are facing one strange problem. The bulk insert command not returning any error though there are errors in script and not inserting data into target tables also.

bulk insert Northwind.dbo.Customers from 'D:\sdfjasdjflasjf.txt'

'D:\sdfjasdjflasjf.txt' - not exist in my dirve. When i execute above statment in Query analyzer i always get

The command(s) completed successfully

If i pass correct file also same message, and not inserting.

Can any one suggest if any settings required to be done? This problem with only this command, remaining all are working fine.

Many thanks in advance.

Soma
   

- Advertisement -