How to use same connection for number of packages

Question

How to use same connection for number of packages

m.bansal

SSC Rookie

Points: 34
More actions
November 26, 2008 at 2:17 am

#194410

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

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

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

krayknot SSCertifiable Points: 7998 More actions · Answer 1

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

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 2

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.

m.bansal SSC Rookie Points: 34 More actions · Answer 3

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

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 4

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

VALEK SSCarpal Tunnel Points: 4206 More actions · Answer 5

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