Mike and Doris Manning
mikedorism at ntelos.net
Wed Jun 4 09:11:34 CDT 2003
Yes you can. You will need to a few references depending on what you want to do. Microsoft DTSPackage Object Library -- required for all DTS packages Microsoft DTSDataPump Scripting Object Library -- Almost always required. It contains the built-in transformations and the DTS scripting object Microsoft DTS Custom Tasks Object Library -- contains the Message Queue Task, the FTP Task, and the Dynamic Properties task. DTSOLAPProcess -- contains the Analytic Services Processing task DTSPrediction -- contains the Data Mining Prediction task OMWCustomTasks 1.0 Type Library -- contains the Transfer Databases task and the four associated transfer tasks. I found SAMS Microsoft SQL Server 2000 DTS (ISBN 0-672-32011-8) to be an excellent resource for VB and VBA automation. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan Geller Sent: Wednesday, June 04, 2003 9:23 AM To: dba-SQLServer at databaseadvisors.com Subject: [dba-SQLServer]Execute DTS from VBA Can I execute a DTS from inside my ADP file in code? How? Access XP, Windows XP, SQL Server 2000. Thanks. --Susan Susan B. Geller Office of Information Systems College of Continuing Education University of Minnesota 306 Wesbrook Hall 77 Pleasant Street SE Minneapolis, MN 55455 Phone: 612-626-4785 Fax: 612-625-2568 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com