• Hi Lynn,

    Yup i tried, it doesn't. Thanks for all the help over here, i have successfully created all the statements needed for my requirement and my target table is derived. Now i shall move on to see if it is possible to do in the SSIS way, which will be out of topic for this forum.

    Thanks.

    Appreciated,

    10e5x