When you write the code producing the name of the file, the file actually has to exist, or you get the file not found error.

You could probably get around this...

To do that last one requires SQL2K or better, because earlier versions don't have the ability to execute a step.

An administrator can change the sa password in the QA without knowing the current password using sp_password.  Eg

sp_password Null, 'New Password', 'sa'

The Null holds the position of the old password.

Depending on what kind of code you're talking about:

If it's a SQL Task, I would use the QA to debug it.

If it's ActiveX Script, I debug in MS Visual Basic. ...

You could also consider using an .ini file to hold the variable which would then be referenced by each package.  Somewhere on this fine website is an article to the...

Also check to ensure that your package is running under a real user rather than the local administrator account.

I am not certain if you mean that there are multiple email messages and that the recepients are getting all but the final email, or if there is a single...

Have you tried eliminating the quotes altogether?

This seems a little more elegant, though I don't exactly know why it works.  I haven't converted it to what you want but you can do that easy enough.  The...

Are you using MTS?

You're welcome.  You may want to consider writing your code this way, as it's less lines than you've written.  The value would go after the field lengths, but the following...

I would not write transactions if I don't need to, but if I need to, performance would have to yield to data integrity.  If the performance were terrible, I might...