I actually did use the DTS but haven't try to save it as a job. Thanks for the help.

Thanks for the help from both of you. Your experiences are most appreciated by rookies like myself.

thank you for the script. It runs fine. My problem is I do not want to create a new table. I just want to make a copy of the table...