Susan Geller
sgeller at cce.umn.edu
Wed Aug 20 09:53:03 CDT 2003
Robert, Thanks! I had just figured that out probably while you were writing this. But, it's good to have this confirmation that I did it right. --Susan -----Original Message----- From: Djabarov, Robert [mailto:Robert.Djabarov at usaa.com] Sent: Wednesday, August 20, 2003 9:43 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer]Using DTS to get data from SQL to Access Click on Execute SQL Task icon in the tool box on the left and specify your Access for existing connection. Type "delete <table_name>" without quotes. Click on OK. Then click on the Execute SQL Task that you created in the previous step and while holding the control key click on the task that inserts data. Both will become highlighted. Right-mouse click and expand Workflow. Select On Success. Done! -----Original Message----- From: Susan Geller [mailto:sgeller at cce.umn.edu] Sent: Wednesday, August 20, 2003 9:12 AM 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com