There is a DTS package that I am having a problem with. I can run it
manually on the server as administor, successfully. However, when I create an
sql job with the SQLSERVER and SQLAGENT using the same user account (smssql)
being a member of the Domain Admin group it aborts.
I'm pretty frustrated with SQL job scheduler, would going to windows job
scheduler be the best? I am not familiar enough with DTS packages and job
scheduling to know what is best.
I would appreciate your recommendations.

Hi,
I was wondering... these jobs which are launching DTS is running as 'sa' or
those ones that own System Administrator as server role?
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)


"Leida" wrote:

Hello Leida,

Have a read of this article as it helps with this type of problem in about
95 % of these cases

http://support.microsoft.com/?kbid=269074


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com