Post reply

deleting a row in SSIS package in a data flow

  • December 30, 2009 at 8:52 am

    #143856

    I want to delete a row in a Warehouse table in the package's DATA FLOW TASK... please help asap

  • December 30, 2009 at 9:06 am

    #1097504

    Use a Conditional Split and send the unwanted row(s) to an output which goes nowhere ...

  • December 30, 2009 at 9:14 am

    #1097514

    see this is what i hav...

    in the database:

    table one: Customer(ID, Name, Age, Location_ID)

    table 2: Location(ID, LOC_NAME)

    in a datawarehouse:

    table 1: Cust(ID, Name, Age, Location_Name)

    now i want to refresh the dataware house without deleting all the data in it... just adding extra rows that are new and removing those rows that have been edited...

    now how can i remove that row...??

  • December 30, 2009 at 9:18 am

    #1097517

    and removing those rows that have been edited...

    [font="Comic Sans MS"]

    Remove or update?

    Try - slowly changing dimension component ...

    [/font]

    [font="Comic Sans MS"]--
    Sabya[/font]

  • December 30, 2009 at 9:22 am

    #1097519

    a.hadss (12/30/2009)

    see this is what i hav...

    in the database:

    table one: Customer(ID, Name, Age, Location_ID)

    table 2: Location(ID, LOC_NAME)

    in a datawarehouse:

    table 1: Cust(ID, Name, Age, Location_Name)

    now i want to refresh the dataware house without deleting all the data in it... just adding extra rows that are new and removing those rows that have been edited...

    now how can i remove that row...??

    Do you realise how different this requirement is from what your first post implies?

  • December 30, 2009 at 9:30 am

    #1097524

    Do you realise how different this requirement is from what your first post implies?

    I didn't see the originial question first :hehe::hehe::hehe:

    [font="Comic Sans MS"]--
    Sabya[/font]

  • December 30, 2009 at 9:39 am

    #1097528

    You chose ... wisely.

  • December 30, 2009 at 9:50 am

    #1097534

    ok sorry for the first post.. cud u please give a solution to my other problem

  • December 30, 2009 at 9:59 am

    #1097539

    As Sabya suggested, please read up on the SCD component and then post back with any additional questions.

  • December 30, 2009 at 10:54 am

    #1097573

    ive made a package for refreshing... all the new rows are getting added.. the SCD is not working tho.. heres the package http://www.4shared.com/get/184818331/aedfd5cb/Chussa.html please please see if u can identify any errors

  • December 30, 2009 at 11:46 am

    #1097592

    someone please help..

Viewing 11 posts - 1 through 11 (of 11 total)

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