SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 xml source
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Flowing Fount of Yak Knowledge

1430 Posts

Posted - 04/30/2008 :  10:05:02  Show Profile  Reply with Quote
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


Very Important crosS Applying yaK Herder

52326 Posts

Posted - 04/30/2008 :  10:13:51  Show Profile  Reply with Quote
I think you need a ForEachFileEnumerator for importing files from a particular folder like this.

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000