Set XML File Source path dynamically
We're using a DTSX package at the moment were we've 'hardcoded' the path to the source XML path (dragging a XML source object to the package and selecting the XML file on the HD for it). The point is, that the amount of XML files we've to import every day is increasing and we can't handle / administrate the packages anymore. My aproach now would be: Having a CSV or XML file that contains all the information to the XML source files (title, filename, etc.). The DTSX package now should create the XML datasource object dynamically on runtime based on the information stored in this CSV or XML file. Is this possible? Can someone give me a hint how to acchieve that? THANX
January 13th, 2010 1:57pm

If you could put the source file in one folder then you could use for each loop to get the data in each file(I assume that the files are of same metadata).Check my blog for details.Hope this helps !! Sudeep| My Blog
Free Windows Admin Tool Kit Click here and download it now
January 13th, 2010 2:12pm

If you could put the source file in one folder then you could use for each loop to get the data in each file(I assume that the files are of same metadata). Check my blog for details. Hope this helps !! Sudeep | My Blog Do you have any example that uses XML Source instead of Flat File Source? Thanks,
February 26th, 2011 8:40am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics