Which controls to Use in SSIS Package for to check each row from the flat file source.

• vikramk1410

  Grasshopper

  Points: 18

  More actions

  April 18, 2011 at 3:52 pm

  #145492

  Hello this is vik , I need some help

  First time i am paling to implement my task in SSIS

  I am having data like 4.5 gB ,i would like to upload into the Sql Server 2008 .

  my data is like combination of 4to 6 tables of data, there is no Primary key .

  one row containing the multiple tables of information

  now i need to split that data in to respective tables.

  my data is like this

  row1: col1, col2, col3...........col125

  Now i have to insert some columns in to master table, if i insert the records in to the master table i have to get last inserted row id and using that id i have to insert coloumns of raw data(col5 to col20 and so on) in to another tables like..

  last inserted row is 5

  table 1

  5, col2

  5 ,col3

  5, col4

  5 ,col5 and has to insert another table

  table 3

  5, col12

  5 ,col32

  5, col45

  5 ,col55

  table 4

  5, col72

  5 ,col82

  5, col95

  5 ,col105 like that from first row.

  can any one suggest me how to implement this task.

  thank you,

  Vik

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  April 19, 2011 at 12:04 am

  #1313181

  If you place different Flat File Sources into one dataflow, you can read out the necessary columns for each table.

  So if you have 5 destination tables, use 5 different Flat File sources, where each source selects only the columns that you need.

  With a script component you can add a rowcount to your dataflow, to incorporate the "inserted row id" requirement.

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