Thanks, Jeff, for taking time to produce an excellent solution. I was going to take time to use Burton Roberts' 2001 function to solve it. I have been using it extensively...

I'm not a Foxpro developer, yet I must comment on what you said, Steve. If for no other reason than healthy PR, Microsoft should do what you have suggested. Your...

SuperExcellentAwesomeCool!

Maybe the geniuses didn't receive help, but the rest of us surely did.

Thank you for taking the time to share with us.

This was so very helpful.

Review the code on the DB to make sure it's all there. You're not passing the contents of the SP thru a variable by any chance? Remember that variables have...

Eirk,

That's OK. What I have suggested stilll allows you to schedule the DTS package. You are still using a DTS package and you are still using the data pump. The...

Erik,

I have not tried to understand the Activex script that you posted, because I do not have the time right now and because I think that you are using an...

Go to Forums Home on this site and search for "backup dts packages". Also, here's a stored procedure that I use for packages and an Activex script for jobs. The...

Thank you for responding.

I am placing all the backups for a single day on a single backup device so that I only had to create a single backup device for the...

I received help from Nigel Rivett's Activex script which I have modified and is listed below. Remember to include the necessary global variables in your DTS package. Each package is...

Also consider the following:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=232301

I especially appreciated Jeet's stored proc that runs a package. But LS hit it on the nose, for he said,...

Jamie's first script gives the package names from sysdtspackages. the second script gives the jobs and step names. However, I cannot see the relationship. Please explain further. We cannot assume...

Great, thoughtful article. will deploy asap.

Glad to help. I have received significant help from this forum and I am happy that I was able to give something back. Thank you for the blessing.

Sorry, I got the first notification but failed to see that it was on the second page.

Remember that you are forming SQL not executing it. After you form...

Not at all; remember the activex task is only forming the SQL and placing it in Global Variables (refer to the Activex sample from the 12/8/2006 3:30 PM post). It...