Hi Everyone

I'm having trouble with my SSIS package using a connection to SQL server and trying to create a connection string using an expression. When I set up the connection, I specify the name of the server (the same server on which I'm creating the SSIS) and the database name, specify Windows Security, and the SSIS package runs fine.

I have created an expression which creates exactly the same connection string as the connection generates on its own, but get this error every time I run it:

[OLE DB Destination] SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONAMANAGE R.
and
[DTS.Pipeline] Error: Component "OLE DB Destination" (315) failed validation and returned error code 0xC020801C
and
"Login failed for user ''. The user is not associated with a trusted SQL server connection."

Any insight is very much appreciated!

Arbon

"A spirit with a vision is a dream with a mission"

__________________
\"A spirit with a vision is a dream with a mission\"