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

I cannot connect an application using OLE DB

When I try to make the connection, the following message appears

"Cannot open database requested in login 'DBName'. Login fails."
Err Code = -2147467259

We are using SQL Server 2000 on NT Server 4.0 SP 6.
The client machine has MDAC 2.6 SP1.

All ideas are welcome.

ThanksSounds like the connection to the server has been made but the login cannot open the database. Could be because the database does not exist or because the login does not map to a valid user in the database.
Try just connecting to master.