SSPI security with SSIS
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.
[DTS.Pipeline] Error: Component "OLE DB Destination" (315) failed validation and returned error code 0xC020801C
"Login failed for user ''. The user is not associated with a trusted SQL server connection."
Any insight is very much appreciated!
"A spirit with a vision is a dream with a mission"
\"A spirit with a vision is a dream with a mission\"