Brent Lipniskis
asked on
Dynamic XML File Source Name - SSIS - BIDS - Visual Studio
I have an data import which downloads an xml file each day. So each day I will have a different file name. Today the file name will be "test_20151104.xml". Tomorrow the file name will be "test_20151105.xml". I have a variable defined with an expression of:
"test_" + (DT_WSTR, 10)@[User::DATE] + ".xml"
The next step is to load that xml file into the database. However, In the dataflow task, in the XML Source Editor, I set the Data access mode to "XML File from variable" and then select the User::Var_FileName where the dynamic file name is stored.
I receive a validation error message that "test__.xml" was not found and the package will not run.
The variable will be set before the XML task executes, but it is not available at before I start the package execution.
Is there a way I can use a dynamic file source in the xml task editor?
"test_" + (DT_WSTR, 10)@[User::DATE] + ".xml"
The next step is to load that xml file into the database. However, In the dataflow task, in the XML Source Editor, I set the Data access mode to "XML File from variable" and then select the User::Var_FileName where the dynamic file name is stored.
I receive a validation error message that "test__.xml" was not found and the package will not run.
The variable will be set before the XML task executes, but it is not available at before I start the package execution.
Is there a way I can use a dynamic file source in the xml task editor?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.