Automic Workload Automation

Expand all | Collapse all

Connection object in SSIS action pack

Jump to Best Answer
  • 1.  Connection object in SSIS action pack

    Posted 06-20-2018 01:21 AM

    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



  • 2.  Re: Connection object in SSIS action pack
    Best Answer

    Posted 06-26-2018 10:08 AM

    rights issue -> solved



  • 3.  Re: Connection object in SSIS action pack

    Posted 06-26-2018 11:20 AM

    Hi ben1984,

     

    Out of curiosity, can you elaborate on what you ended up doing to resolved it (in term of the "rights issues") so in the future if other community member run across this, they'll have an idea something to look at/try.