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.
| Author |
Topic |
|
BhaskarDasari
Starting Member
19 Posts |
 Posted - 2008-03-19 : 05:42:31
|
| Hi,i want to create single xml configuration file which should include the details to configure all the files in all packages.Usually as u know whenever we configure the package one xml config file is created where we can change the path name for file or database details.Like that we will create a xml config file for each package.but i want the solution as on xml config file for multiple packages |
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2008-03-26 : 14:13:34
|
| The main package will require all variables that need to be passed to secondary packages.In the secondary packages go to menu SSIS >> Package Configuration>Instead of creating XML configuration file select "Parent package variable".Select the variable you want to pass from Main package to Secondary package.Hope this helps. |
 |
|
|
|
|
|
Creating xml configuration file with project scope