1

I have created an SSIS package that takes a pivot view (so the fields are dynamic) and exports it into a recordset. I was able to export the recordset to an Excel file using ActiveX, but when deployed on the server, it does not allow ActiveX. Is there an easy way to export a recordset to an Excel file otherwise? I can't use the Excel destination in SSIS because the field names are dynamic and can change.

Hadi
  • 36,233
  • 13
  • 65
  • 124
Todd
  • 83
  • 4

1 Answers1

0

You can export recordset to excel file using a Script Task (C# or VB.NET).

You must select the recordset variable as ReadOnly Variable within the Script and implement your own logic. In order to do that, there are many examples posted online, as example:

Hadi
  • 36,233
  • 13
  • 65
  • 124