Post reply

Scheduling DTS Package

  • August 16, 2005 at 7:31 am

    #94589

    I have  created a DTS package that updates my SQL Server database from Excel.It initially deletes all the records from my SQL Server Database and then inserts the records from Excel files...

    It works fine when I run it manually...But when I schedule it ,it just doesnt functions in proper manner....It just leaves my SQL Server database with no records in it...

    Can any1 help me out with this problem...

    Thanks in advance for the help...

     

    Kindest Regards

    Jol

     

    Kindest Regards,

    Joel

  • August 16, 2005 at 8:24 am

    #582469

    Log onto your database server using the same account that you use for the SQL Server service. Now run the DTS and see if you get any errors.  Also, check the ownership of the SQL Agent job that gets created when you schedule the DTS. Set it to be owned by the service login.

    Robin HC

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

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