I'm a bit lost.
When I execute a DTS package via the SQL Server Agent I get a Permission Denied for CreateObject after the job successfully creates an object.
Set cn = CreateObject("ADODB.Connection") works
... some code...
Set ftp = CreateObject("doFtp.Ftp") fails
When I log in as the the proxy account/job owner the DTS runs fine.
When I put the job and dll on a test server it runs with no problems as a scheduled job.
The Job executes as the service account. (At least thats the message in the job history)

I'm running Sql 2000 SP3

The dll is one I created in VB. Here's what I've done so far:

The service account the SQL Server Agent starts under and the Proxy Account are both System Administrators.
The owner of the job is the Proxy Account.
I've run dcomcnfg and specifically added the Service Account and Proxy Account.
I've validated that the Service Account and Proxy Account have access to HKLM\software\Microsoft\Ole
I've specifically granted permissions for the proxy account and service account to the directory and file containing the dll
I've stopped and restarted SQL Server Agent.

298725 - PRB: Scheduled DTS Package Fails With "Permission Denied:
CreateObject"
(http://support.microsoft.com/default...5&Product=sql2
k)



--
Darren Green
http://www.sqldts.com
"Larry Charlton" <LarryCharlton (AT) discussions (DOT) microsoft.com> wrote