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
  • 7,782
  • 6
  • 22
  • 55
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.McDermaid 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
  • 45,811
  • 27
  • 120
  • 136
Baris
  • 11
  • 1