Post reply

Import Xml Files into DB - Data Flow Task with Xml Source and OLE DB Dest.

  • February 21, 2008 at 8:33 am

    #378850

    Hi Folks,

    I would like to import a set of xml files with different names and content but with the same structure.

    When I setup the Data Flow and run the package it runs ok.

    But when I try to change the xml file (for testing a second file), the OLEDB destination pops-up with :

    "Validation error. Import File: DTS.Pipeline: input column "FLAG_ORIG" (686) has lineage ID 2495 that was not previously used in the Data Flow task.", and I need to Remap the columns manualy (Bad, as I want to schedule this package to run automatically through all the files).

    Is there an option to be able to do an auto "Re-map" for all the fields ?

    I tried to rename the fields to distinct them but it does not help. Any advice ?

    Thanks and regards,

    leonqf.

  • February 22, 2008 at 1:02 am

    #780972

    OK, got it.

    The trick is to rename the files to a same name before loading it. So you don't have to change the source path and avoid the system to remap the fields.

    Thanks for your thoughts,

    leonqf.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply