Hello

I am trying to create a package that will dump the data from one table into another and delete the table from the primary table after the export is done. Any help would be good

Currently I have a Microsoft OLE DB Provider for SQL Server and a Transform Data Task that goes to another Microsoft OLE DB Provider for SQL Server. This export process works but how can I delete the data from the 1st Microsoft OLE DB Provider for SQL Server.

You should be able to do this by adding an Execute SQL task to your package
and then placing a precedence constraint between it and your existing
TransformData task such that it fires the Execute SQL task after the
TransformData task has completed. In the Execute SQL task then you'd
include the DELETE statement to cleanout your table.

--
--Brian
(Please reply to the newsgroups only.)



"Lontae Jones" <anonymous (AT) discussions (DOT) microsoft.com> wrote