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:12:49
|
| Hi,My Problem goes Like this....I have a folder which contains all the flat files which are used by all the packages(ex--flat file connection managers) in my project.If we want to change the name of the folder(or)move the folder(path may change),have to change in every package( in all connection managers) manually.It looks hardcoding and timetaking.Is there any way to change in one place(xml,file,variable) so that it should be affected in all the packages. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-19 : 06:03:30
|
| Yup..you can definne the folder path as a configuration variable and map xml as source . so that you need to change only the xml file to change the path. |
 |
|
|
BhaskarDasari
Starting Member
19 Posts |
Posted - 2008-03-19 : 06:11:24
|
| But scope of configuration variable is package.how can it be visible for other packages in project. |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-03-19 : 10:54:49
|
| It looks like your other topic is a duplicated of this one, I'll repost part of my reply here.If this is what you need, you can build the connection string dynamically using ssis expressions and store that as a variable, at the execution time would be pass a parameter to the ssis package, which would be the folder name.It maybe be doable using the xml file you're referring to, but I've never done that way. |
|
|
|
BhaskarDasari
Starting Member
19 Posts |
Posted - 2008-03-24 : 02:05:26
|
| ya i have created for xml file by using "package configurations" option in ssis menu.Through that xml which will be having connection details for database and path for flatfile.But this xml can be created for a package and will not be visible for other packages in aproject for reuse.(we can reuse in the same package that too the connection managers are accessing the same database and same path for flat files)In this case i have created 3 variables 1)folderpath 2)source filr path 3)destination file pathThe fact is we have two appraoches creating variables (or) creating xml .If you want to change the paths you will have to modify either in variables or in xmlBut my req is that variable or xml should be used for all the packages.(Note:we can create variables with scope package but not for project) |
|
|
|
|
|
|
How can i configure Dynamic Folder