Post reply

Load flat file source data to different destination flat files.

  • March 17, 2011 at 8:19 am

    #147608

    Hi all,

    I am new to SSIS I need help for the below scenario...

    I had a flat file source, I want to move half of the data to one destination flat file and another half to another destination.

    please help me for this scenario 🙂

    Thanks in advance.

  • March 17, 2011 at 9:59 am

    #1300035

    Can you provide how your flat file data looks like?

    Thanks.

  • March 17, 2011 at 10:24 am

    #1300053

    Look into using the Conditional Split Data Flow Transformation in your Data Flow task.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • March 17, 2011 at 7:41 pm

    #1300302

    Hi thank's for u r response..

    my flat file data is :- fred,milk,10

    ride,beer,15

    fin,milk,18 etc like this it a comma separated data.

  • March 17, 2011 at 7:45 pm

    #1300303

    hi than's for your response.

    I am aware of conditional split but what my question is

    I had one file in that file 50 records are there I want to move 25 records to one file and another 25 records to another file.

    How should i maintain the counter in the data flow.

  • March 18, 2011 at 1:30 am

    #1300338

    You'll probably need a script component to add a rownumber, so that you can use a conditional split to split the data.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 18, 2011 at 11:13 am

    #1300681

    ...Or you can use a third party component, Row Number Transformation. You can download it here: http://www.sqlis.com/sqlis/post/Row-Number-Transformation.aspx

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

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