Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Shared connexion between package

Author  Topic 

SQL_NewBee
Starting Member

2 Posts

Posted - 2008-04-21 : 05:15:21
Hello,

Here's my problem :

I have several packages, one parents and several childs.
I want to define just one connexion for all theses packages, so I used a Data source. But I had several problem with that object.
So I'm looking for the best way to define one working database connexion for all my packages.

Can someone help me ?

Thanks in advance.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-04-21 : 11:38:36
I think you need to have a look at setting package configurations

http://www.sql-server-performance.com/articles/dba/package_configuration_2005_p1.aspx
Go to Top of Page

SQL_NewBee
Starting Member

2 Posts

Posted - 2008-04-21 : 12:08:58
Thanks.
I'll try that.
Go to Top of Page
   

- Advertisement -