Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2008-04-30 : 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.xmlThis 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.xmlfriday -> V5 CDS Composites65496845732.xmlsaturday --> 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 Compositesis it something like V5 CDS Composites*.xml? - notice the asteriskThanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-30 : 10:13:51
|
| I think you need a ForEachFileEnumerator for importing files from a particular folder like this.http://www.sqlis.com/55.aspx |
 |
|
|
|
|
|
xml source