Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jan 2001
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Running DTS in Access (2000)

    Is posible run a SQL DTS from Access?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Running DTS in Access (2000)

    Not that I know of. As far as I know, you can only run DTS packages from the Enterprise manager, or via the SQL Server Agent. And while it will work with Access tables, there are lots of potential gotchas associated with things like security files and ODBC connections.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •