Regarding SSIS

• mithun.gite

  SSCrazy

  Points: 2333

  More actions

  November 17, 2009 at 11:42 pm

  #206595

  Hi Friends,

  We are facing once issue due to code page 65001 , as 65001 is not supported in 2008, we want to use ssis to insert the data from flat file to table, which is working fine when we tested for the one table.

  Now the problem is there we have 84 tables in one dataset, for which we want to insert the data in tables.

  See our Sp will pick the first table , it will make the call to SSIS and then SSIS will take the file and insert into the table, this is what we want to achive, currently the sitaution is like we have to create 84 packages , each one for each table, but anybody have any idea how we can write only one package which can pick up the file and insert the data in to table and also map the columns dynamically....

  Seems not possible but , please share if someone has any idea or option or any way which we should give it a try..

  Any reply will be appriciated..

  Thanks

  -Mithun

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  November 17, 2009 at 11:59 pm

  #1080699

  I take it that the 84 structures are different..

  Basically with SSIS all you can really do is build a package programatically and then execute it.

  The big issue is that the structure really can't chage at run-time..

  CEWII