I have created a ssis package which uses an xml source and and ole db destination. It basically transfers the data from an xml file on my machine into a table in the sql server database. This .xml file is in cownloadsV5 CDS Composites1209558837833.xml This is the file that has been placed here automatically by a third party tool. When my ssis package imports the xml data into sql server, I then move this .xml file into another folder on my machine. So every day there is a new .xml file which has the same name except the numbers are different as follows: Thursday --> V5 CDS Composites1209558837833.xml friday -> V5 CDS Composites65496845732.xml saturday --> V5 CDS Composites1642389243.xml ... ... ... Question: In the xml source, xml location what do I put there to only look for the xml file which starts with V5 CDS Composites is it something like V5 CDS Composites*.xml? - notice the asterisk Thanks
Why don't you rename the file to a standard name before inserting the data and rename it back to original after insert...
