AnsweredAssumed Answered

Connection object in SSIS action pack

Question asked by ben1984 on Jun 20, 2018
Latest reply on Jun 26, 2018 by Luu Le

Dear all,

i'm new to Automic and currently i try to configre the SSIS action pack.

 

https://marketplace.automic.com/details/executing-published-microsoft-ssis-packages

 

In the connection object we have to provide server information where the SSISDB is hosted.

 

Our SSISDB is located on following server (example)

 

vmpSSISDB\SSIS01:Port

 

Is it possible that Automic has an issue with this syntax?

 

I tried already those syntaxes:

 

[vmpSSISDB\SSIS01]:Port

[vmpSSISDB\SSIS01:Port]

"vmpSSISDB\SSIS01":Port

"vmpSSISDB\SSIS01:Port"

 

When i choose Generic JDBC connection I can connect to this server without any problems. But when i choose this option, i guess i have to change a lot of configs in this action pack because its recommending MSSQL connection type.

 

Maybe someone has an idea.

 

Thanks in advance.

 

Have a nice day.

 

best regards,

Ben

Outcomes