Why not use Package Logging?  Granted, it takes up spacce, but I think you can get what you need from there (ie troubleshooting why a package failed).

It sounds like to me there is a small, if not, large market for an application that does this for you.  The app could select a database, run through each stored...

Thanks ewilson20.  Unless anyone else out there has a good way of handling this, I think my only solution is to script out all SPs before going to prod and...

Maybe I didn't make my problem clear enough.  I have a stored procedures in my database that resides on my development server.  This same server contains databases that my stored...

Xnl28, I found what I was talking about.  We had to go to MS to get a HotFix.  It was Hot Fix for Microsoft Knowledge Base article number Q814113.  Bascially,...

Not necessarily.  You could use an INI file or something like it to read in the two variables you need and then use the Dynamic Task property.  The trick...

If I remember correctly, this has to do with a problem in SP3.  At the moment, I can't remember exactly what fixed it, but I think it was an update...

Glad to see you found a way to do it!  Never really had to change the delim before!!!  Thank goodness.

One of the easiest ways of doing this is to have global variables to hold the following:

Database Name = gvDatabase

File Base Path = gv FileBasePath

Destination File = DestinFile

Create an ActiveX...

If you are running SS2K, you may want to read up on using the Execute Package task and the Dynamic Property task.  How we do this is we specify in the...

Doing a quick test, if you set your global variable = to {CR}{LF} rather than the VB equivalent and  use the Dynamic Property task, you should be able to set...

Thanks guys.  This is exactly what I needed.

Excellent!!!  Thank you so much.  I will give this a shot.

Well, that is what I thought too.  That is why i have the second task (Do Successful Task) on the failure side of my sample.  It still comes out as...

I guess I'm not illustrating my problem very well.  Consider the following:

The second task is to check for a file.  To the right of...