I didn't change the exception file for the new environment...

Couldn't you open up the transformation script and either save the script as a file, or copy the contents of the script into Word, etc.

Do the 'servers' need to be linked? You could manage connections through your application running on IIS with ADO.

Did you find a solution to this? If not, did you verify that you had privileges to write to the destination table?

-Corey

Thanks for the response but I actually implemented a solution I found at http://sqldts.com

For those interested...

(1) Created a dummy Select statement with a parameter

(example: Select...