• mtassin - Wednesday, June 13, 2018 2:50 PM

    I'd recommend using Cozyroc for this.  The Data Flow+ Task SSIS component has the capability to dynamically map columns on the fly

    Hi Mark,
    Yes, I did think about that option too. Had I been the DBA responsible for the server, I might have been inclined to use a commercial component and be done with it. But I'm a developer and so I have to depend on other people to buy a licence and install the product on the server. And all that takes a lot of time which I did not have.
    Being a developer, I like to roll my own, whenever possible.
    Regards,
    Hiske