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 syntax

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-12-14 : 10:52:59
Danny writes "I am trying to run bulk insert from sqlserver 2000, but keep getting the error 'C:/test.txt' does not exist, inspite the file is there.
Thanks,"

efelito
Constraint Violating Yak Guru

478 Posts

Posted - 2001-12-14 : 11:11:48
Is this inside of a DTS package? If so and you are running it manually from a client machine it will be looking on the local harddrive for the file. If you are scheduling it, the package will look for the file on the server's harddrive. Also, verify that path reads 'c:\test' and not 'c:/test'

Jeff Banschbach
Consultant, MCDBA
Go to Top of Page
   

- Advertisement -