Batch calling "dtsx" does not connect to Avaya CMS

Asked

Viewed 124 times

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.

sql sql-server batch ssis

1 answer

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

  • 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.

  • 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.

Browser other questions tagged sql sql-server batch ssis

You are not signed in. Login or sign up in order to post.