SQL Server Performance

DTS

Discussion in 'SQL Server DTS-Related Questions' started by bfarr23, Apr 29, 2004.

  1. bfarr23 New Member

    is there a way with DTS to copy data from source to destination
    and filter on the source data before it is copied?

    like ".....where status = 1"







    bfarr23, Apr 29, 2004
    #2

  2. harsh_sr New Member

    1. Use "User a Query to specify data to transfer" in 3rd step(Specify Table Copy or Query) of DTS.
    2. Goto Query Builder
    3. Select the columns needed
    4. You can specify the creteria in next screen.

    HTH
    Harsh
    harsh_sr, Apr 29, 2004
    #2

  3. bfarr23 New Member

    But its already setup for
    "Copy SQL Server Objects".

    your way i would have to re-create the package.




    bfarr23, Apr 30, 2004
    #2

  4. satya Moderator

    Yes if the current package is set to transfer tables, then you need to recreate another one for completion using DTS wizard.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Apr 30, 2004
    #2

Share This Page