DTSSQLIMPORT error

We are rec'ving the following error when we try to run a pkg from a remote machine and the pkg has been created while logged onto the Server machine.

any ideas? thanks in advance.

-dinzana
[Dest tblBSIXData [506]] 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.".Remember that a package runs on the machine from which you launch it.

The best way to execute a package on the server (ie the machine on which it is stored) is to create an unscheduled SQL Agent job for the package, and to run sp_startjob from the client.

-Doug
|||

I am recieving same message, when I am trying to import data from Excel file & exporting it to a Sql Server database on Sql serve database located on different IP (location) .

Can you help me.

|||

Are you using the SQL Server Destination component? This destination is only for use on the local server.

-Doug