DTS Package - truncate, drop index and migrate data in same DTS package

Hi,

I created a DTS package that migrates the data from a table on one
server to another. (The DTS package contains a Connection1, the source
server, the transformation and Connection 2, the destination server)

Connection 1
|
|
|
Connection 2

Prior to executing the above DTS package, I maunally truncate the
table and drop the index on the table located at Connection 2.

I would like to drop the index and truncate table prior to migrating
the data. But I would like to do it in the same DTS package.


Thanks in Advance
.

Relevant Pages

  • Re: setup an offline connection
    ... If you are calling the package in VB then you can simply use the object ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > the laptop to a client, I would like to modify the DTS package to ... > delete the connection to my computer and put the connection to their ...
    (microsoft.public.sqlserver.dts)
  • Re: Kill job that is executing endlessly
    ... executes the DTS package in question), insert a record into a log table with ... I have *zero* control over the Informix server, ... > the connection to the Informix server, ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Package - truncate, drop index and migrate data in same DTS package
    ... server to another. ... server, the transformation and Connection 2, the destination server) ... table and drop the index on the table located at Connection 2. ...  But I would like to do it in the same DTS package. ...
    (microsoft.public.sqlserver.dts)
  • setup an offline connection
    ... server and a laptop. ... I would like to modify the DTS package to ... delete the connection to my computer and put the connection to their ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Package - truncate, drop index and migrate data in same DTS package
    ... I created a DTS package that migrates the data from a table on one ... server to another. ... server, the transformation and Connection 2, the destination server) ... I would like to drop the index and truncate table prior to migrating ...
    (microsoft.public.sqlserver.dts)