Steve, Well done!!!

I am not a SQL developer at all but have been forced into this because I have 3GL background LOL and appearently overly ambitious. So I have a new 2005 database going live in two months and have to create a monthly migration package. I am learning SSIS on my own because my Company cannot afford training. Enough of my sad story. I have some questions on your diagram because I need to do the same thing and I got the same errors and I want to make it dynamic like yours. I have questions on the Looping and passing the list of objects from the storage to the DROP FOR LOOP.

I hate beg but if you have a moment you might be able to get me on the right track.

My name is Steve Cogan

My email is scogan@zoomtown.com if you are intested in answering some questions send me an email and I will email back.

Sincerely,

Steve Cogan