1

I have created a ssis package to import multiple excel sheets to database table.

So far, i could import all columns to database table but i need another column that keeps sheetname for the main columns.

I used variable for excel sheet and it is pretty succsessful.

How can i add sheet name as an extra column?

Amira Bedhiafi
  • 8,088
  • 6
  • 24
  • 60
Baris
  • 11
  • 1
  • If your sheetname is in a vairable, add it to your dataflow in a derived column transform, _or_ run an `UPDATE` query afterwards to apply it to your table – Nick.Mc May 24 '20 at 06:07
  • Does this answer your question? [How to loop through excel file and get sheetname using ssis 2008](https://stackoverflow.com/questions/45097309/how-to-loop-through-excel-file-and-get-sheetname-using-ssis-2008) – AmilaMGunawardana May 24 '20 at 13:59

1 Answers1

-1

As Nick mentions in a comment:

If your sheetname is in a vairable, add it to your dataflow in a derived column transform, or run an UPDATE query afterwards to apply it to your table

I created a derived column and changed it's size , everything is ok.

Bhargav Rao
  • 50,140
  • 28
  • 121
  • 140
Baris
  • 11
  • 1