Configuration File

  • 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

  • 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

  • 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