Post reply

Edit a SSIS pakcage without Visual Studio

  • November 9, 2016 at 8:32 am

    #318785

    This might have been already been answered already but could not find it. Apologize if repetitive. I created a SSIS package just by exporting data from my database but need to change the query a bit that exports. I opened Integration Services within SSMS and see the package but cannot modify the query. How can I modify the query without recreated the package again? I do not have Visual studio installed.

  • November 9, 2016 at 8:44 am

    #1911418

    You need to have Business Intelligence Development Studio (BIDS) or SQL Server Data Tools installed, depending if it 2008 or 2012+.

    These are part of the SQL Server installation, as long as it isn't Express edition.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • November 9, 2016 at 8:50 am

    #1911419

    This isn't the recommended way, but if it's only the query you want to modify, and you have no other way of doing it, you could edit the package file in a text editor. Make sure you have a backup of the file first, then find the query and make the changes. You have tested the query outside of the package, haven't you?

    John

  • November 9, 2016 at 8:55 am

    #1911420

    Packages can easily be edited in a text editor as far as one doesn't change script component's scripts which are build and stored in a compiled form.

    😎

  • November 10, 2016 at 6:30 am

    #1911645

    I tried to export the package through SSMS integration services and does not export. Not sure how to do that.

  • November 10, 2016 at 10:02 am

    #1911705

    Ah, I got it finally. I was leaving the Package Location on SQL Server rather than clicking the drop down. Thanks all for the knowledgeable input.

Viewing 6 posts - 1 through 5 (of 5 total)

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