Converting .xlsx file to .xls or csv format in SSIS

Question

Hi - I have a requirement to convert the .xlsx file to .xls or .csv format through SSIS.  Please tell me how can I achieve it in SSIS.

thanks

Answer 1

You can use a simple data flow task for that inside SSIS with excel source and excel destination assuming you dont have to do any transformations in between. In case of csv use flat file destination.

You just need to make sure connectionstrings are specificied correctly for xls and xslx

https://www.connectionstrings.com/excel/

---

Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page

Answer 2

Thanks Visakh.  But let me explain my problem here.  We are getting 64-bit excel 2013 (.xlsx) file as source. In our server we have 32-bit driver to read 32-bit excel 2013.  Our DBA's are denying to install 64-bit driver since there are already few SSIS packages are using 32-bit drivers to read 32-bit excel 2013. Though we conveyed them that 64-bit driver can also read 32-bit excel files, they are not convinced.

The work around am thinking is,  In SSIS package, convert the 64-bit excel 2013 to either .xls or .csv file and process it.  That is why am looking for a solution to convert the .xlsx to .xls or .csv.

hope i make my requirement clear

thanks

Answer 3

Thanks Visakh.  But let me explain my problem here.  We are getting 64-bit excel 2013 (.xlsx) file as source. In our server we have 32-bit driver to read 32-bit excel 2013.  Our DBA's are denying to install 64-bit driver since there are already few SSIS packages are using 32-bit drivers to read 32-bit excel 2013. Though we conveyed them that 64-bit driver can also read 32-bit excel files, they are not convinced.

The work around am thinking is,  In SSIS package, convert the 64-bit excel 2013 to either .xls or .csv file and process it.  That is why am looking for a solution to convert the .xlsx to .xls or .csv.

hope i make my requirement clear

thanks

There is no bit-ness stored in the Excel file. You can read a file with either 32bit or 64bit drivers. Just setup your SSIS package to execute in 32bit mode and you should be fine.

---

SSIS Tasks Components Scripts Services | http://www.cozyroc.com/