sql server - SSIS process for saving .xlsx file as .csv file

Question

I am trying to download a .xlsx excel file from FTP server and save it in a .csv file format. I was able to download a file from server using ftp task in SSIS and save it in a local folder now I want to save that file as csv file format for import process. I could not find a conversion method or task from .xlxs to csv. i tried script task but it didn't work. can someone please help.

Answer 1

You can add a Script task to achieve this, and inside the script you can use Interop Library:

• Converting XLSX file using to a CSV file
• Convert .xlsx & .xls to .csv
• How to Convert Excel to CSV using Interop