Post reply

Access mdb to SQL Server 2000

  • June 8, 2006 at 6:00 am

    #366370

    Hi

    I have created a DTS package that connects to an Access mdb database and brings data into a SQL Server 2000 table.  This Access database itself has linked tables to another database.

    When I run the DTS package manually it works fine. However, when I run it as a job it fails.  I have given SQL Server Agent rights to access the folders - but it still doesn't work.

    Does anybody have any ideas?

    Thanks

    Paul

  • June 8, 2006 at 6:41 am

    #642499

    I'm sure you've already thought of this, but if the reference to the Access DB refers to a drive letter, it may be a different letter for the SQL Agent - are you using a UNC?

     

    S

  • June 8, 2006 at 7:18 am

    #642519

    Thanks, Stewart

    Dead right.  I originally had it mapped to the server as normal, but a copy adopted a drive letter. 

    Silly mistake, and again many thanks

    Paul

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

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