[dba-SQLServer]Using DTS to get data from SQL to Access

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



More information about the dba-SQLServer mailing list