Porter, Mark
MPorter at acsalaska.com
Wed Jun 4 13:23:34 CDT 2003
there are also great resources at www.sqldts.com -----Original Message----- From: Mike and Doris Manning [mailto:mikedorism at ntelos.net] Sent: Wednesday, June 04, 2003 6:12 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer]Execute DTS from VBA 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com This transmittal may contain confidential information intended solely for the addressee. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error; any review, dissemination, distribution or copying of this transmittal is strictly prohibited. If you have received this communication in error, please notify us immediately by reply or by telephone (collect at 907-564-1000) and ask to speak with the message sender. In addition, please immediately delete this message and all attachments. Thank you.