Reusing SSIS packages? RRS feed

  • Question

  • Hi Experts,

    I've created one SSIS package in my local machine which can load the data from Excel file located in my local machine to new table in Dev server. 

    It executed fine and giving expected result and now I want to reuse the same SSIS package in Test and Production environments.

    How can I achieve this best possible way?

    Please help.

    Thanks in advance


    Thursday, March 21, 2013 12:11 PM


  • Hi Noorbi,

    What you are asking for is not reusing the package, but executing the package in/for test/production environments.

    To achieve this, you can build the SSIS package in dev, deploy it in Test/Production environments edit the package configurations(Excel source path, Destination DB etc) according to the environment and execute the package.


    • Marked as answer by SQL2012BI Thursday, March 21, 2013 12:25 PM
    Thursday, March 21, 2013 12:17 PM