Post reply

DTS Import/Export task thread does not terminate

  • July 22, 2004 at 6:38 am

    #108886

    Hi All,

    I have 3 DTS packages that transfers data from 3 .mdb files to SQL Server. They  execute clean when I run manually from the EM. When I run then using the SQL Server Agent as a schedule task, they create 2 threads each, which do not terminate even after the package has completed. The data transfer is not clean either.

    Any insights to resolve this without manually killing the processes or by active x script?

    Thanks

    Pranav

  • July 23, 2004 at 7:32 am

    #515877

    The "usual suspect" here is permissions.  Try logging into your box and into EM as your SQL Server Agent and see what happens when you execute the Tasks manually.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply