January 22, 2009 at 7:41 am
Guys,
I need to store the location of a text file in an xml configuration file. I managed to do that by storing the location in a variable (ex. "C:\TextFiles\"). I need this in order to run a Flat File Source dynamically, as the flat file location might change.
Does anybody know how to use the variable in the configuration file as a location to the File Data source ?
Thanks
January 22, 2009 at 11:19 am
You don't need a variable to be able to set the file path in configuration. While setting up the configuration select Connection Managers-> Connectionstring(select this).
This will make the path configurable.
But if you wish to use the variable you can go to Variable-> Value(select this) to make this variable configurable.
HTH
January 22, 2009 at 11:43 pm
Thanks for the answer.. will try it out
Thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply