April 22, 2009 at 9:51 am
when iam executing a pckage of importing an xml file to a table iam not getting any error but iam getting the destination red color.
And the status bar shows the message like this..
SQL Server Destination [752]] 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.). Make sure you are accessing a local server via Windows security.".
[SQL Server Destination [752]] Error: Unable to prepare the SSIS bulk insert for data insertion.
[DTS.Pipeline] Error: component "SQL Server Destination" (752) failed the pre-execute phase and returned error code 0xC0202071.
Can sme one plz help in this issue
Thank you
April 22, 2009 at 9:52 am
Make sure the SSIS package is on the same server where you're running the insert. That usually solves that problem.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 7, 2011 at 11:26 am
I have the same problem as Ashy4Blue.
Never mind. Changed the destination from SQLServer to OLE DB and that took care of the problem.
Thanks.
YeahMan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply