none
What does strategy exist to deploy SSIS package and my own data flow components into a enterparise server?

    Question

  •  

    I created a SSIS package and several data flow componenets for this package. 

     

    What does strategy exist to deploy SSIS package and data flow components into a enterparise server?

     

    Thanks in advance.

    Thursday, March 29, 2007 12:50 PM

All replies

  •  DeniusValiant wrote:

     

    I created a SSIS package and several data flow componenets for this package. 

     

    What does strategy exist to deploy SSIS package and data flow components into a enterparise server?

     

    Thanks in advance.

     

    I don't know of any existing "strategy" for doing this. I guess people would deploy custom tasks and components in advance before deploying packages as you would normally.

     

    If you come up with something different perhaps you could share it?

     

    -Jamie

     

    Thursday, March 29, 2007 8:30 PM
    Moderator
  • Probably what you are asking, the ways in which one can deploy the packages.

    If so,

    1. You could use the manifest file to deploy the package

    2. You could deploy the package by using the Import package option in SSMS

    3. Command Line utility tool

    Well i have used a procedure to delete the packages (which are stored in msdb tables) and then used a batch file to install all the packages in the server

     


    vinu
    Wednesday, September 01, 2010 1:32 AM