• Thanks for your help. Our DW runs on Netezza. I don't have any issues connecting to it from SSIS. I am still having a hard time understanding the entire process. I'm gonna go ahead and give your approach a shot.

    Thanks again