Post reply

How to transfer the Data to Different Files Based On Values in Column.

  • July 26, 2012 at 2:46 am

    #261623

    [/b]Hi,I want to

    perform One Activity in SSIS.

    My Requirement is,

    I have a table tbl_target with following sample data,

    Lnnoodccalcddt LnAmt BaseDate OdcFlag

    12012-06-30 00:00:00.00010000.00 2012-03-31 00:00:00.000OpeningBal

    22012-06-15 00:00:00.00040000.00 2012-03-31 00:00:00.000Complete

    32011-12-01 00:00:00.00080000.00 2012-03-31 00:00:00.000NULL

    42012-06-01 00:00:00.000100000.002012-03-31 00:00:00.000OpeningBal

    52012-06-01 00:00:00.000100000.002012-03-31 00:00:00.000Complete

    In this Column ODcFlag,it has three distinct Values,

    1)OpeningBal

    2)Complete

    3)Null

    Now,My requirement,

    is based on the values in the odcFlag Column I want to transfer this data to Different Tables,

    for example,Value with OpeningBal should be route to one file and so on.

    Please suggest me how to do this ,

    Its urgent for me.

    Please Help me !

    Thanks in Advance!

  • July 26, 2012 at 4:47 am

    #1517827

    In your dataflow, add a Conditional split to split the data stream into three outputs.

    Each of the outputs will go to its own file destination.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • July 26, 2012 at 4:58 am

    #1517831

    Hi,

    Conditionall Splitt Will do for me.

    Now I am using OLEDB Destination.

    I am having around 100000 rows ,which is better OLEDB Or SQL Server Destination.

    Please help me.

    Thamks in Advance!

  • July 26, 2012 at 5:29 am

    #1517839

    Personally, I'd stick with OLEDB.

    You might like to read this[/url] for attempts at comparisons.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • July 26, 2012 at 5:33 am

    #1517840

    hi,

    Thanks !!!!!!!!!!!!!!!!!!!!!!!!

  • July 26, 2012 at 5:36 am

    #1517842

    Hi,

    Doing so I am getting error,in Conditional Splitt task as,

    [Conditional Split [16]] Error: The expression "OdcFlag == "Complete"" on "output "OdcFlag is Complete" (161)" evaluated to NULL, but the "component "Conditional Split" (16)" requires a Boolean results. Modify the error row disposition on the output to treat this result as False (Ignore Failure) or to redirect this row to the error output (Redirect Row). The expression results must be Boolean for a Conditional Split. A NULL expression result is an error.

    [Conditional Split [16]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Conditional Split" (16)" failed because error code 0xC020902B occurred, and the error row disposition on "output "OdcFlag is Complete" (161)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.

    [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Conditional Split" (16) failed with error code 0xC0209029 while processing input "Conditional Split Input" (17). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.

  • July 26, 2012 at 5:39 am

    #1517845

    Can OdcFlag ever be NULL?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • July 26, 2012 at 6:21 am

    #1517878

    Yes,

    I can replace with blank,will it solve my problem.

    Thanks!

Viewing 8 posts - 1 through 7 (of 7 total)

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