I have a simple DTSX package that takes a CSV file and loads it into a table in SQL Server 2008 Ent. x64 bit (on 2008 Ent. Server). The package runs well when DTEXEC is executed locally on the server which it resides on. I run into trouble when I try to execute the package using PSExec like so:
C:\>c:\pstools\psexec \\myservr -u "mydom\myuser" -p "mypass" dtexec /FILE "X:\ETL\packages\test1.dtsx" /CHECKPOINTING OFF /REPORTING EW /DECRYPT mykey
The package encryption is set to "EncryptAllWithPassword", which I supply along with DTEXEC "/decrypt" attribute. The error I am getting is "SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MyDB" failed with error code 0x80004005. There may be error messages posted before this with more information on why the AcquireConnection method call failed."
When the package is executed locally, the user connection properties are exactly the same (Windows Authenticated connection, using an administrative account). The account specified in the SSIS log below (mydom\myuser - modifi
View Complete Post