Rename .xlsx file to .csv file in ssis 2005

Question

Hi,

Am loading the file from the below path:

D:\SSIS\1812212_Sample.xlsx.

Client asked me to change the file as CSV format and load the data

How to rename .xlsx file to .csv file using SSIS 2005 in the same folder D:\SSIS\?

Am using Filesystem task.

Regards

SqlStud

Answer 1

Renaming it won't do any good, you need to actually convert it from xlsx (ms xml) to csv (comma separated)

---

Chuck Pedretti | Magenic – North Region | magenic.com

Answer 2

Renaming it won't do any good, you need to actually convert it from xlsx (ms xml) to csv (comma separated)

---

Chuck Pedretti | Magenic – North Region | magenic.com

Thanks Chuck,

Is there any option to convert from xlsx to csv using ssis 2005?

Regards

SqlStud

Answer 3

Couple options that I can think of

1) Use a data flow to move data from excel source into csv destination (silly if you are going to import the csv after that)

2) Use a script task that uses the Excel automation libraries to open the file and export to csv

---

Chuck Pedretti | Magenic – North Region | magenic.com

Answer 4

Couple of codeplex projects that might point you in the right direction for option 2

http://www.codeproject.com/Articles/246772/Convert-xlsx-xls-to-csv

http://exceldatareader.codeplex.com/

---

Chuck Pedretti | Magenic – North Region | magenic.com