2

I am trying to create drop down columns in already existed Excel Sheet using Script task. I know that we can do it using C# but not sure is it possible in SSIS Script task. If it is possible please guide me.

I am new to SSIS technology.

Hadi
  • 36,233
  • 13
  • 65
  • 124
Chandana Puppy
  • 133
  • 1
  • 9

1 Answers1

0

Yes you can do it in Script task since it is a C# project where you can use external assemblies such as Interop.Excel.dll

Example:

Hadi
  • 36,233
  • 13
  • 65
  • 124