How to use same connection for number of packages

  • Hi all,

    I have 100 package in my project. I need to deploy this project to some other server. At that time i am using sepearate connection for each project so if i deploy i need to changes the connection for each package. How can I use the same connection for all package so that i change the server name at one location and it gets reflected for all packages.

    Thanks,

    Manish Bansal

  • m.bansal (11/26/2008)


    Hi all,

    I have 100 package in my project. I need to deploy this project to some other server. At that time i am using sepearate connection for each project so if i deploy i need to changes the connection for each package. How can I use the same connection for all package so that i change the server name at one location and it gets reflected for all packages.

    Thanks,

    Manish Bansal

    you can use the single connection but make sure that the connections must be close after use

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • If I am understanding you correctly, you want to be able to redirect all of your packages to a different server easily.

    Look up "Package Configurations" in books online.

    The setup is in the SSIS menu in BIDS. It will allow you to use an XML file, environment variable, or table to store connection strings (or pretty much any other component property). With this, you can use a single XML configuration file for all of your packages (assuming you used the same connection manager name in all of them) and will be able to change the connection in one place without opening each package.

  • Hello,

    Thanks a lot.

    Can u plz tell me how can i use this configuration file or how to create this configuration. Please send me the link for more detail for this. I am still not getting it.

    Thanks

    Manish Bansal

  • Have you searched on "Package Configurations" in books online? The setup is a wizard, you should be able to follow their instructions.

  • m.bansal (12/1/2008)


    Hello,

    Thanks a lot.

    Can u plz tell me how can i use this configuration file or how to create this configuration. Please send me the link for more detail for this. I am still not getting it.

    Thanks

    Manish Bansal

    Rght click on backgroud space of your DTSX package and choose Package Condifuration.

    There it should be fairly straightforward.

    Do not foget to sneak in the conf file (table), which is created as a result. This will give you an understanding how it works etc so that you avoid frustration later on.

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

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

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