I'm attempting to import a table from Access to Sql Server using the
Data Transform Task, however i'm unsure how to first clear the
destination table of data. I'd rather not use a Execute Sql Task
because of the number of tables involved. Is it possible to use some
feature of the Data Transform Task, or possible use ActiveX in some
way to iterate through the Data Transform Tasks in the DTS packages
and clear the data that way?

Thanks Matt

You could certainly use the ACtive Script tasks yes

You could loop through the DestinationObjectName property of the DataPump
task and then against the connection of the destination issue the correct
statement

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Matthew Sickler" <sickmat (AT) iit (DOT) edu> wrote

I would just use the execute sql tast.
use the
truncate table statements.
Using execute sql task would be as safe as suing ActiveX or any other thing.
sickmat (AT) iit (DOT) edu (Matthew Sickler) wrote in message news:<fe09cb3e.0409080833.543c343 (AT) posting (DOT) google.com>...