Flowing Fount of Yak Knowledge
Posted - 04/30/2008 : 10:05:02
| 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 c:\Downloads\V5 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
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