Post reply

DataFlow task

  • September 2, 2009 at 11:28 pm

    #210285

    Hi,

    I am using DataFlow task and i would like to delete rows before inserting the data into the table based on a

    condition.Please suggest on how can i do this .guess i need to use script component but i am not sure

    about complete details on how to proceed on this

    Thanks for the help

  • September 3, 2009 at 11:19 am

    #1048941

    Just to clarify;

    you want to delete rows in the destination table before inserting new data.

    True or false?

    And based on what kind of conditions?

  • September 4, 2009 at 10:44 am

    #1049517

    Trying to do a delete/insert operation in a specific order should be done either with 2 different data flows, or a data flow and an Execute SQL Task. Can you post more information about what you're trying to accomplish?

    Tim Mitchell
    TimMitchell.net | @tmitch.net | Tyleris.com
    ETL Best Practices

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply