CODEWITHSUNDEEP
ssisetl
Sreejesh Kumar
Sreejesh Kumar

Reputation: 2499

bulk insert task issue

I am facing a issue with Bulk Insert Task, which tries to pull data from .DAT file to SQL server table. The error which I am getting is as follows :

Cannot bulk load because the file "C:\Localpath" could not be opened. Operating system error code 3 (Could not find the path)

It would be helpful, if you could help me out.

Upvotes: 0

Views: 784

Answers (1)

Mark Wojciechowicz
Mark Wojciechowicz

Reputation: 4477

A BULK INSERT task in SSIS works in the context of the SQL Server which it is being executed from. So if you have a package executing on Server A and it executes a Bulk Insert task on Server B, it will look for the file on Server B, unless you are using a UNC path.

Using a UNC path could introduce other problems however, such as the need for kerberos in order to authenticate to the SSIS Server. This could be your situation, or you could have simply passed the wrong path to the task. In either case, it is ridiculously simpler to configure and troubleshoot a data flow task. I would suggest trying that as a replacement.

Upvotes: 2

Related Questions