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.
| Author |
Topic |
|
chsundar
Starting Member
4 Posts |
 Posted - 2005-09-08 : 02:54:26
|
| 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 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-09-08 : 03:07:02
|
| Check that file at the computer where SQL Server is installedMadhivananFailing to plan is Planning to fail |
 |
|
|
chsundar
Starting Member
4 Posts |
Posted - 2005-09-08 : 09:57:57
|
| That file was not exist in the computer where Sql server installed. But stil it not giving error message |
|
|
|
|
|
|
Bulk Insert - Strange message