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

On Jun 10, 3:02 am, matteus <matteog...@xxxxxxxxx> wrote:
On Jun 10, 5:22 am, research_stuff <learnstu...@xxxxxxxxxxxxx> wrote:





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

Hi, you must use the Execute SQL Task.
If you want to use only one task, then you must separate each
statement with GO. It should be something like this:
DROP INDEX...
GO
TRUNCATE TABLE...
GO

Alternatively you can use 1 Execute SQL task for each statement and
link one task to each other with a OnSuccess constraint (Workflow
menu).

Sorry for bad english, hope it helps anyway.
Bye,
Matteo- Hide quoted text -

- Show quoted text -

When I do that, the command affects the source table not the
destination table.
.

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
    ... 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)
  • 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: -----Outgoing Email DOWN ------ Please help
    ... It looks like your Exchange Server is having trouble connecting to the destination server. ... Then check your path and make sure that the Exchange server can contact the destination server, and you don't have some sort of firewall or other device in the path that might be interfering with mail flow. ... "The remote server did not respond to a connection attempt." ...
    (microsoft.public.exchange.admin)
Loading