July 10, 2009 at 7:09 am
I have a SSIS package that needs to run on my production server...A little background...Two files are put on the production server...The SSIS package truncates two tables...then loads two tables using those two files...When I was testing I was able to run the package except I had it connecting to my local...And it worked fine...It saw the path to production server to receive those two files, it truncated the two tables, it then loaded the two tables with new data from the two files...However it is the same package except I changed the connection to load production thinking it was going to work fine and everything would be good...I ran the package, it truncated the two files...Then when it went to the data flow process...It gave me an error saying it could not locate the files...Here are the error codes - Error Code 0xC0202071 and Error code: 0x80040E14....Any help would be greatly appreciated!
July 10, 2009 at 8:02 am
Please post the full error message, not just the codes.
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
July 10, 2009 at 8:25 am
Excuse me Im sorry:
[SQL Server Destination [8775]] Error: An OLE DB error has occurred. Error code: 0x80040E14.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14
Description: "Could not bulk load because SSIS file mapping object 'Global\DTSQLIMPORT
' could not be opened. Operating system error code 2(The system cannot find the file specified.).
And I found the other one!
July 10, 2009 at 8:29 am
Permissions issue? Your user has permissions while the user that SQL runs under does not? I see it all the time..
CEWII
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply