LOAD DIFFRENT EXCEL SHEET IN DIFFRENT DESTINATION TABLE

Question

Dear All,

I am new in ssis

i have two excel sheet  with diffrent structure.

1st excel sheet have 5 column and 2nd  excel sheet have 8 column.

i want to load each sheet in diffrent destination tables.

i know how to load excel sheet with same strucure in table but dont know with diffrent structure.

plesae suggest me step by step.

for last 10 days i am working on same.

please do the needful help as soon as possible.

 

thanks & regards,

Vipin jha

Answer 1

Just create two different dataflows, one for each sheet.

ps: your caps lock is broken

---

MCTS, MCITP - Please mark posts as answered where appropriate.

Answer 2

Create two DFT's(Data flow Task)

and in each DFT specify you explicit sheet name and target table name and that should solve your problem.

---

Mark as answer if the post help you... Regards, Indraneel A

Answer 3

Check this... http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/13604da4-c4d4-4ad0-915a-0ab31cb07ad9

---

Mark as answer if the post help you... Regards, Indraneel A

Answer 4

is there are 2-3 excel sheet then its ok to create 2 diffrent DFT

but suppose there are 30 excel sheet then is that a good way.

is there any other alternative

vipin jha

Answer 5

is there are 2-3 excel sheet then its ok to create 2 diffrent DFT

but suppose there are 30 excel sheet then is that a good way.

is there any other alternative

 

vipin jha

Answer 6

Let us not suppose. Give us a brief idea of what are we looking at.

---

Please vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar | My Blog

Answer 7

If all the excel sheets have the same structure, you can re-use the same dataflow.
If not, you need to create 30 different dataflows, at least with SSIS out of the box.

You can purchase a commercial component from CozyRoc, dataflow+, that can handle changing metadata.

---

MCTS, MCITP - Please mark posts as answered where appropriate.