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 : 09:26:16
|
| i have created one package which contains flat file source and flat file destin and corres conneciton mgrs.i created configuration using package configurations with name config.dtxconfig.(while creating it i selected connection string under source file and destination file).config.dtxconfig contains path as config value for source c:\folder\filesourc.txt.and for destination c:\folder\filedest.txtBut my req is we have to create another xml named as folderpath.xml should contain the path up to c:\folder\.for every package execution ssis should access this xml where it should find the folder.if i want to change the name of folder (or ) move the folder i should change in folderpath.xml only wihout changing folder name in all configuration files.can i do that.if not give me alternate solution.plz guide me with clear explanation since i am novice to this tool |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-03-19 : 10:52:18
|
| If I understood correctly, you need to change the name of a folder at runtime and the filename will remain the same (I got confused when you threw xml on the mix). 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. |
 |
|
|
|
|
|
folder path configuration