[dba-SQLServer] Local Tables

Mike & Doris Manning mikedorism at adelphia.net
Tue May 18 06:42:26 CDT 2004


Create a Local DTS package.  Set up the first DTS Export task.  Then make
copies of that task and change what needs to be changed for the other 9
MDBs.  Then link the tasks together using On Completion arrows so that they
fire one after the other.

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 Martin Reid
Sent: Monday, May 17, 2004 5:25 PM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Local Tables


I need to do a multi table select from SQL Server and Insert the resulting
data into 10 linked Access MDBs. Never tried this before. Any ideas?


Martin

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com





More information about the dba-SQLServer mailing list