Thanks for posting the script. Looks like a complex one. I have a very silly question. Where should I give the name of my DTS package that I want to...

That would be really kind of you if you can post that script. Also will I have to use username and password method(User:sa) to connect to database. Right now I...

Is this because I am using SQL Server 7 and not 2000?

Well, I went into the Package Properties after right-clicking in the blan space but I could not find the option for logging. I have 3 tabs when I click on...

Thanks!!! That looks awesome. I will try and let you know how it goes. Thank you so much.

Thanks!!! I am a newbie in using DTS package. Can you tell me how do I enable logging while executing DTS package. Also does anyone have any example which shows...