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
