I get this error using Sql Server Destination

Does anyone have any idea?

I was using OLE DB DESTINATION and after going to Sql Server Destination task:

[SQL Server Destination [11259]] 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.".

?

TIA

What happens when you try with an OLE DB Destination?

I never use SQL Server destinations so I'm not sure if the file not found error is your fault or something with your installation.

Can you explain a bit more of your data flow?

|||The SQL Server Destination requires that the SQL Server is local (on the same computer) as the executing package. Is that the case in your scenario?|||

Did you try doing a search? : http://search.live.com/results.aspx?FORM=QBJK&q1=macro%3Ajamiet.ssis&q=Global%5CDTSQLIMPORT

You cannot use SQL Server Destination if you are inserting to a server that is not the same as the one on which you are running the package.

-Jamie