"Chris Dunigan" <chris.dunigan@agwsha.nhs.uk> wrote in message
news:41ffb33f$1_2@127.0.0.1...
> Hi Andy,
>
> Yes the DTS Package works fine when I run it from Enterprise Manager;
> and I have used the correct server name, username, password and
> packagename.
>
> Having done some more digging into this error I found a site that told
> me it could be something to so with the software installed on the PC on
> which the database resides.
> I think I might need to ensure that dtspkg.dll is correctly installed
> (along with a host of other dll and rll's).
> As I can't get hold of our IT guys today I haven't been able to see if
> this solves my problem.
>
> Does this sound like it may fix the problem??

If no dts package works when run from a job on the server.


Quite frankly, I'm confused by your huge initial post as to which technique
you're trying and what's going on.


I'm wondering if this is running and owned by a user can run the dts package
OK on the server using whichever of the alternatives you posted you're
currently trying.

Try this with the package if it's vbscript using any activex.
Open DTS Designer, right-click the task, select Workflow, then Workflow

Properties. On the Options tab, check "Execute on main package thread"


--
Regards,
Andy O'Neill