hi

Question

hi

susheel.surabhi

Grasshopper

Points: 22
More actions
December 5, 2008 at 3:52 am

#127316

[Bulk Insert Task] Error: An error occurred with the following error message: "Cannot bulk load because the file "C:\Documents and Settings\susheel\My Documents\f2.txt" could not be opened. Operating system error code 3(The system cannot find the path specified.).".
can any one help me out why i am getting this error
can i have solution for this

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

dave-dj SSChampion Points: 11297 More actions · Answer 1

have you tried opening the file from somewhere like c:\file.txt

_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

MarkG Ten Centuries Points: 1237 More actions · Answer 2

I'm not sure if you're running this in BIDS or as Deployed.. but either way, I believe that if you enable Package Configurations (right-click on workspace, click on Package Configurations..) and if you will locate the checkbox for the Connection Manager file you're looking for (C:\f2.txt), then under Properties, just check the box for ConnectionString. At that point you can see what path SSIS is expecting to find - and you will know if that path actually exists on that server (or local pc). Change the path to a known, valid path.

If you are running this manually via BIDS then it will use your security context as the Package Creator - so as long as YOU have the required rights/privilidges to that location - it should work (and the file exists, if you're loading FROM the txt file). If you deploy to SQL and running as a scheduled Job, then you should look at creating a Proxy Account that contains the necessary Credentials to run (along with appropriate permissions to the file location).

I had a slightly different problem where somehow the paths to the various *.dtsx files had the wrong location - I was able to override those values by changing the ConnectionString property of each of the affected dtsx files.

Brian Knight has a good video on SSIS Configurations plus lots of other topics on JumpStartTV.com.

Hope this helps..

LOOKUP_BI-756009 SSCertifiable Points: 7286 More actions · Answer 3

Susheel,

Is the .txt file located on the same location as the SQL server ?

This was taken from msdn

The source file that the Bulk Insert task loads can be on the same server as the SQL Server database into which data is inserted, or on a remote server. If the file is on a remote server, you must specify the file name using the Universal Naming Convention (UNC) name in the path.

Also If text file is on your machine, is the folder shared ?

http://msdn.microsoft.com/en-us/ms141239.aspx

susheel.surabhi Grasshopper Points: 22 More actions · Answer 4

s i have tried by palcing the text file from destok top as well as c:\\my documents

but i am getting the same error

COZYROC One Orange Chip Points: 28499 More actions · Answer 5

Can you try to load the file from the root c:\ ? I think the task is somehow messing because of the _spaces_ in the path.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

dave-dj SSChampion Points: 11297 More actions · Answer 6

just reading, some of the other posts another thing that may also be worth checking is folder permissions. (i've been caught out before, be incorrect folder permission and of course a completely misleading error message).

_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)