The stored procedure is used in triggers on multi-databases.  In most cases, there is not a need to pass it an expression.  The developer did not want to have to...

These are people outside our company.

I copied to MS Access database to a local drive on the SQL Server box and got the same results.

The MSAccess database is on a different server (file/print) than SQL Server.  I have logged onto the SQL Server with full admin rights, even used the SQLServer account...didn't make any...

How would you "edit" the package under sql2005?

Updating the name is not what I want.  I need to COPY the DTSs from DTS4_ to DTS9_CDJ_.  The key to sysdtspackage is NOT name, but id and version id.

From my experience it more likely a numeric field.  Example moving 99.99999 into int field.

Things to consider...

1) how are the dts making their connections?  If they are using standard SQL OLE connections, then you would need to check each one and hope they are...

Thanks,  this seems to work!

Results from:

update openquery(BHOBHT01,'SELECT A.RECORD_PROCESSED FROM BHDBO.T_ERP_MOM_TRANS_OUTGOING A

INNER JOIN db1_Porini_Rep.dbo.MOMTRX_Pull B ON A.UNIQUE_TRANS_NO =B.UNINO')

set RECORD_PROCESSED = 'Y'

Server: Msg 7321, Level 16, State 2, Line 1

An error occurred while preparing a query...

I've tried that also...see 4th try in original posting

Results from:

update openquery(BHOBHF02,'Update BHDBO.T_ERP_MOM_TRANS_OUTGOING

  set RECORD_PROCESSED = 'Y'

From MOMTRX_Pull

where UNIQUE_TRANS_NO =MOMTRX_Pull.UNINO')

Server: Msg 170, Level 15, State 1, Line 2

Line 2: Incorrect syntax near 'Y'.

I was finally able to get by this...

The person who installed SP1 was not the administrator and in installing they created a new set of files for report server on...

Did I mention we are running SQL2005 SP1.

I tried the under SQL Managment Studio (SQL2005 verion of EM), but the end result is the same...still getting the internal error.

We are using an NT account to manage the RS service.

Please explain what you mean by re-assign.