SQL Server Performance

xml source

Discussion in 'SQL Server 2005 Integration Services' started by arkiboys, Apr 30, 2008.

  1. arkiboys Member

    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:DownloadsV5 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
  2. MohammedU New Member

    Why don't you rename the file to a standard name before inserting the data and rename it back to original after insert...

Share This Page