January 27, 2011 at 7:42 am
I have a pretty simple SSIS package that has a connection manager to a flat file, connection manager to a DB table and code to see if the flat file exists and if there is data in it.
Once these pass I want to Bulk Insert the data into a SQL table, but the Bulk Insert task keeps telling giving me an error: 'Can't find path to file "P:\FilePath\file.txt"' ?
In the Bulk Insert task I have the connection manager for the DB table as the destination connection and I have the connection manager for the flat file as the source connection.
If I test the connection managers individually they are working, but I still get the 'Can't find path to file' error when I run the Bulk Insert task.
Anyone have any idea what I'm doing wrong?
January 27, 2011 at 9:15 am
Are you running the package as yourself, or another user? It is good practice to use a UNC path to your file, rather than drive letters, as these are not always mapped the same for all users.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
January 27, 2011 at 11:26 am
That did the trick. Thank you so much Phil!
January 27, 2011 at 12:43 pm
A pleasure.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply