Post reply

Import Data from CSV into different Tables.

  • November 12, 2007 at 1:49 am

    #118814

    Hello Folks,

    Every day I recive a csv file that should be loaded in to two different tables depending on a certian value on each line.

    My csv look pretty much like this

    20050707;15:59;00;Some text

    20050707;16:59;00;Some other text

    20050707;17:03;01;Some text goes here

    The third column is a record type description, when ever the value is 00 the line data should be redirected to a table A and whenever the recordtype is 01 the line data should be redirected to table b.

    Whats the best way to achive this ?

    Thanks in advance.

  • November 12, 2007 at 2:08 am

    #750167

    1. Use Flat File Source, name all column to human readable form (for example name this column to Type)

    2. Add path from the source to Conditional Split component

    3. add two outputs:

    - one with name type_00 and condition Type == '00'

    - two with name type_01 and condition Type == '01'

    4. each path for this conditions add to ole db destination.

    MP

  • November 12, 2007 at 4:19 am

    #750190

    Thanks, that helped.

    However I encountered another problem now.

    While executing the package, I notice that there is thirten rows in the source file during the execuation phase, but at the end nothing is added to my destination

    my source and destination are two different files.

    Thanks for any help.

  • November 12, 2007 at 4:31 am

    #750196

    How many rows are displayed near each path outgoing from conditional split component? How many rows are input to this component?

    Please post screen capture of execution task.

    MP

  • November 12, 2007 at 5:15 am

    #750202

    Here you get the printscreen

  • November 12, 2007 at 5:23 am

    #750206

    Please give me the view of mappings in ole db source and view of output definition for conditional split and overall view of this package diagram.

    MP

  • November 12, 2007 at 7:09 am

    #750236

    I hope this helps.

    Thanks a lot for your effort.

  • November 12, 2007 at 10:06 am

    #750312

    Condition for output name type_00 should be:

    RecType == '00'

    and for output name type_01 should be:

    RecType == '01'

    Nothing more.

    MP

  • November 12, 2007 at 1:49 pm

    #750369

    Hello,

    That was the solution, the reason why I had ISNULL in there was because it solved another problem.

    Thanks a lot

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

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