How to deploy SSIS package from dev environment to production

Posted on 2014-08-26
Last Modified: 2016-02-11

Please advise how i can deploy SSIS packages dynamically from dev to production environment without changing  connection string of individual packages manually.

Question by:isonali
    LVL 20

    Expert Comment

    by:Marten Rune
    I'd definatily go for deployment using powershell to automate this routine.
    To get you started:

    Regards Marten
    LVL 3

    Accepted Solution

    In an effort to make SSIS deployment easier, SS 2012 introduced the SSISDB Catalog, which a db to hold all connection strings etc.

    If you're using 2008, this article shows how to set up config variables:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Viewers will learn how the fundamental information of how to create a table.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now