Is posible run a SQL DTS from Access?
Results 1 to 2 of 2
Thread: Running DTS in Access (2000)
-
Lounger
- Join Date
- Jan 2001
- Posts
- 39
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2002-06-04 14:22Running DTS in Access (2000)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Super Moderator
- Join Date
- Aug 2001
- Location
- Evergreen, CO, USA
- Posts
- 6,358
- Thanks
- 0
- Thanked 22 Times in 22 Posts
2002-06-05 02:09Re: 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
