Problem with VBScript DTS Package on remote MSDE2000

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Frank Rizzo via SQLMonster.com (forum_at_SQLMonster.com)
Date: 01/17/05 

Date: Mon, 17 Jan 2005 00:12:01 GMT

I have a Package that I run on a remote server ( Win2k3, MSDE2000+SP3a) using the DTSRUN command on that server. It is a simple script that connects to the data base and sends out emails. I used to be able to execute this Package inside of the Enterprise Manager (EM). I cannot pinpoint exactly when, but at some point along the way I made a change to the server either with hotfixes or a ICF change, but I could no longer use EM to execute the Package. I tried changing the connection string etc. I don't have the expertise to dbug this, so I am hoping someone here can help. I execute the Package now by running the DTSRUN command.

Does anyone know why this would break and what debug steps can I use to try and fix this problem?

--Frank 

-- 
Message posted via http://www.sqlmonster.com