I'm really looking forward to the release of 2005 and SSIS, it seems to solve all the deficiencies of DTS.

Bryan

Thanks all for the suggestions/info!

Mikes suggestion was most along the lines of what I was looking for.  

Again thanks for all the input. 

I tried this but it seems to report the name of the computer running the script rather than the name of the computer where the DTS is hosted.

Thank You,

Bryan

What I am specifically trying to do is point our connections to the right server depending on whether the DTS script is on our test or production server.  For example,...

That did the trick.

Thank You Remi! 

Bryan

The error occurs on the first time throught the loop when the loop counter ='s 1.  When I check the value of oCustTsk.Assignments.item(0) it throws an error ( oCustTsk.Assignments.item(0) Run-time exception thrown...

From BOL

ANSI_NULL_DEFAULT

Allows the user to control the database default nullability. When NULL or NOT NULL is not specified explicitly, a user-defined data type or a column definition uses the...

This is the worst question I have ever seen here.  There is no such thing as middle join.