August 1, 2007 at 12:59 pm
Hi all,
can any on please let me know whey this is occuring!! I am trying to get data transfer to SQL using package
[SQL Server Destination [37]] Error: SSIS Error Code DTS_E_OLEDBERROR. 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.".
August 2, 2007 at 1:56 am
Are you using a SQL destination? If so, is the package running on the same machine as the SQL instance you are trying to connect to? SQL Server Destination MUST be on the same server as the package is run.
Use a OLEDB Destination instead.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply