Problem running script to execute ssis package....
Posted: 13 Jun 2007 4:26
I'm trying to execute an MSSQL ssis package from a Control-M job.
I use the command line format to execute the dtexec utility....
dtexec /SQL [server] / [package]
The problem is that the connections in my package are defined using Windows Integrated security. When the package tries to connect, I get a login error with the user identified as "NT Authority/Anonymous Logon".
I has assumed that the domain account that I am using to run Control-M would be passed to the package but this does not seem to be the case.
Using SQL Server authentication on my package connections does work, but I prefer to use Integrated security.
Is it possible? And how can I do it?
Thanks.
I use the command line format to execute the dtexec utility....
dtexec /SQL [server] / [package]
The problem is that the connections in my package are defined using Windows Integrated security. When the package tries to connect, I get a login error with the user identified as "NT Authority/Anonymous Logon".
I has assumed that the domain account that I am using to run Control-M would be passed to the package but this does not seem to be the case.
Using SQL Server authentication on my package connections does work, but I prefer to use Integrated security.
Is it possible? And how can I do it?
Thanks.