Inserting row from a table into another table from SSIS

• cbrammer1219

  SSCarpal Tunnel

  Points: 4476

  More actions

  September 18, 2014 at 1:50 pm

  #293333

  Hello all I have a conundrum, I have a 2010 SSIS package where I am reading csv files with different fields and formatted data, I have created separate packages for each file and I am formatting the data to fit the final destination tables data elements, I've been instructed to create 7 separate packages to read each file and the format the data from the 7 csv files, and insert into their table tbl1, tbl2, tbl3...etc then, I'm taking a execute sql task and wanting to insert the tbl1, tbl2, tbl3...etc into destination table that will be the final table for all reports and other uses.

  1 should I create a ID?

  2 these files will be read once a month

  3 I want to append the data, not drop and recreate each run,

  4 It's 2012 SQL and 2010 SSIS

  each csv file is in a different format, some have 15 columns, other have 8 I have to parse the data, in SP to align with the fields

  in the destination table.

  5 Can I force RowID to be the next auto gen number from tbl1,for the start of insert for tbl2, then last row of tbl2 for insert of tbl3???

  Thanks you