I am getting the following error when I try to debug a package that needs to Copy Columns from an AS400 database into SQL 2005: [SQL Server Destination [1684]] 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.". Has anybody seen this error and what do I need to do and check for? Thanks for the information.

Yes, this error has been posted to this forum many times. It means you are trying to use a SQL destination to access a SQL Server that isn't local (i.e. the one the SSIS package is running on). To usea sql dest you need to run the package on the PC that the SQL Server is on. If you can not then you need to use an OLEDB destination instead. HTH, Matt

Matt, Yes, I did some more digging and I did find this thread...http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=74428&SiteID=1. The answer was there. Thanks

I've posted to a couple of the forum threads that discuss this topic. I am getting this exception, too. However, I am using OLEDB connections and they work sometimes and sometimes they don't. I can't figure it out. Here is a specific of what I am receiving. Maybe someone will see something in the error that I am overlooking. My file is there. I can see the columns, data in the file source connection. So, it isn't that my file doesn't exist. But, where is this Global\DTSQLIMPORT file? Why would this run sometimes and then decide not to run only to run again some other time with no changes having been made? Thanks in advance. [SQLDest TE [45]] 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.".

I resolved my issue by correcting the fact that my DB Destination was pointing to the wrong connection manager.

Why this isn't at the top of the FAQ list mystifies me. It's the first the you do wrong.Facebook: Zamdrist Roleplaying: Elliquiy