Post reply

Azure Data Studio for managing SSIS packages?

  • December 20, 2021 at 2:36 am

    #3965367

    Hello all,

    I was wondering if anyone knows of a way to manage SSIS packages using Azure Data Studio? For example, I'd like the functionality of deploying packages:

    SSIS_Management2

    ...and checking on the results from packages that have run in the past:

    SSIS_Management

    I've Googled and searched this forum but can't find any information on it. This is one of the last bits of functionality I need that SSMS has that I can't find Azure Data Studio....yet. I'm considering making the jump to a MacBook however, I need to be able to manage SSIS packages and SSMS does not run on MacOS. However, Azure Data Studio will run on MacOS.

    I'm open to other ideas/tools as well.

    Thanks!

    • This topic was modified 2 years, 11 months ago by  BigMF.

  • December 20, 2021 at 5:35 am

    This was removed by the editor as SPAM

  • December 20, 2021 at 9:57 am

    #3965455

    Presumably, you are using SSDT to do the SSIS development? You can deploy from there. You can also deploy using PoSh, which is what I do in our CD environment.

    You may check on the results of package executions by querying SSISDB directly, or by looking at the All Executions report.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • December 20, 2021 at 7:13 pm

    #3965657

    To add to what Phil said, my understanding is that ADS (Azure Data Studio) is more of a "development" tool and SSMS is more of a "management and administration" tool.

    Deploying SSIS packages is more of an administrative task which is why it is likely not included in ADS.

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply