• Hi There,

    The reason we wanted to do this in SSIS was because we pull data from a lot of various sources in our data warehouse and instead of relying on SQL logic which could have varied by database server or version, I wanted to do this on our ETL side of things.

    Thanks!

    Garima

    http://edw.northwestern.edu