0
I created a service in dtsx
that needs to connect to CMS Avaya
.
It turns out that when I run it through Visual Studio it follows the process until the end normally.
But when I call one batch
it does not allow authentication.
0
I created a service in dtsx
that needs to connect to CMS Avaya
.
It turns out that when I run it through Visual Studio it follows the process until the end normally.
But when I call one batch
it does not allow authentication.
1
Are you running this DTSX per command line in your batch? If yes, pass the login and password parameters to the base. in Dtexec, we have the /U --> User and /P -- Password
If it is not that, you can post what is appearing error.
[]s
Browser other questions tagged sql sql-server batch ssis
You are not signed in. Login or sign up in order to post.
Hey, Advaldo, thanks for your help. I am passing as follows: dtexec /FILE "E: SSIS Principal_prod.dtsx" /Decrypt "[password]" /CHECKPOINTING OFF /REPORTING EWCDI [password] = my decryption password.
– user6490
Try this: dtexec /FILE "E: SSIS Principal_prod.dtsx" /Decrypt "[password]" /CHECKPOINTING OFF /REPORTING EWCDI [password] = my password for decryption /Rep The only change was the /Rep parameter that generates a report (log). See what it generates from error.
– Advaldo Paiva Moreira