Home Forums Article Discussions Article Discussions by Author Discuss content posted by Hiske Bekkering Dynamic File Column mapping in SSIS. RE: Dynamic File Column mapping in SSIS.

  • June 12, 2018 at 1:23 pm

    #1993765

    jonathan.crawford - Tuesday, June 12, 2018 9:55 AM

    So now I just need one task to do everything, I just need to store the mappings in my table.

    Perhaps a bit sarcastic, but still....nice solution!

    Hi Jonathan,

    Nope... You can store your mappings anywhere you like! Could even be an XML file. The point being that storing the mappings outside of the code makes them configurable. It just happened to be the case that the mappings table was already there, having been used by the DTS 2000 package before the migration.

    Regards,

    Hiske