Susan Geller
sgeller at cce.umn.edu
Wed Aug 20 09:26:43 CDT 2003
I figured it out. I just added an Execute SQL task that deletes the data. Sometimes it's the simple things that stump me. Paul, I'm going to schedule the DTS to run nightly to refresh data in an mdb. The mdb is really just a copy of my SQL Server database data. The reason I'm doing this is so that my users can have a place to do ad-hoc query writing without needing to give them access to my SQL Server tables. I'm also doing some denormalizing to make it easier for them to do ad-hoc queries. In addition to scheduling this to run at a specific time during the night, I plan to let them execute the DTS from Access so they can have fresh data midday if they need it. I already have that part mostly worked out. --Susan -----Original Message----- From: paul.hartland at fsmail.net [mailto:paul.hartland at fsmail.net] Sent: Wednesday, August 20, 2003 9:19 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer]Using DTS to get data from SQL to Access Are you using Access or Visual Basic to run the DTS, or directly from SQL Server ? From: "Susan Geller" <sgeller at cce.umn.edu> Date: Wed 20/Aug/2003 14:12 GMT To: <dba-SQLServer at databaseadvisors.com> Subject: [dba-SQLServer]Using DTS to get data from SQL to Access I have written a DTS that populates a table in my Access mdb. What I want is for the DTS to first delete all the data that is currently in the access mdb and then repopulate it with the data from my SQL table. I can't figure out how to do the delete part from the DTS. Does anybody know or where can I go to look for help on this? --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 ________________________________________________________________________ __ Join Freeserve http://www.freeserve.com/time/ Winner of the 2003 Internet Service Providers' Association awards for Best Unmetered ISP and Best Consumer Application. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com