• Hi Gangadhar,

    This can be acheived fairly simply using two variables.

    Firstly Create one variable called something like DateString or similar. Set its EvaluateAsExpression property to true and enter an expression that will build a string for todays date in the format you haver stated, YYYYMMDD? (Ask if you want me to give you the expression for this)

    Then create a second variable called FilePath or something similar and again set its EvaluateAsExpression property to true and set its expression to "<PATH TO FILE>\\" + @[User::DateString] + ".xml"

    Obviously replacing <PATH TO FILE> with a path relative to your package where the files will be stored

    Then in the connetion manager for the xml source file view the properties, in there click the three dotted elipse button on the "Expressions" property. In the box that pops up set select "ConnectionString" in the property column and type @[User::FilePath] in the Expression column

    This will then dynamically set the connection manager to look for a file with todays date on

    Hope this Helps

    Cheers

    Dave