Execute Access VBA Macro from DTS -- sql server dts

RLoski
2/28/2007 11:41:15 AM

Do you want to delete all of the records in your access database?
--
Russel Loski, MCSD.Net

[quoted text, click to view]

ricky
3/1/2007 12:00:00 AM

Good morning

Thank you for your reply. I was wondering if one is able to specify which
records in a table to delete, but if that is not possible, then clearing
down all records in the Access Database will be sufficient, since I may wish
to keep some generic lookup tables, but this may not be an issue, since I
could probably upload the data via another datapump.

Kind regards

Ricky

[quoted text, click to view]

AlterEgo
3/1/2007 10:27:09 AM

ricky,

You can use the "Execute SQL Task".

1. Add a connection to the Access DB.
2. Add an Execute SQL Task using the Access connection from step #1.
3. Enter whatever delete statement you want for the SQL Statement field:

delete from MyTable where ...

-- Bill

[quoted text, click to view]

ricky
3/2/2007 4:11:07 PM

does that mean there is no real way to interact with VBA Macros contained in
MS Access from DTS?

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : Execute Access VBA Macro from DTS