Post reply

Need help on how to deploy SSIS packages

  • February 3, 2009 at 6:45 am

    #130269

    HI,

    I am new to SSIS packages and I would like to know the best way to deploy the packages. I heard that there is something called Configuration file which i need to make use for deploying.. Could anyone help me in this.. or by providing some link which can help me to learn about SSIS deployment?

    Thanks,

    Suresh

    Regards,
    Suresh Arumugam

  • February 3, 2009 at 7:15 am

    #937102

    By now you might already know about the different deployment modes: File System and SQL Server (msdb), if you dont do lookup "Creating a SSIS manifest" and "Microsoft Project Real". they would give you adequate info about deployments and configurations. There are tradeoffs in file system vs the sql server deployment, you need to understand the performance implications and maintainability of each deployment mode. I hope this was helpful. I could go on and on about using SSIS configurations and variables for deployments but it is a vast topic.

  • February 3, 2009 at 9:00 am

    #937212

    I also recommend reading "Deploying Integration Services Packages" in BOL. These articles helped me when I was setting up my first package deployment:

    http://www.sqlis.com/post/Easy-Package-Configuration.aspx

    http://technet.microsoft.com/en-us/library/bb945074.aspx

    Greg

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

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