Pls gudie me how to convert excel to .csv format using SSIS
use export and import wizard,
in the export wizard you can select source file as excel file and the destination file as flat file or CSV file.
Save the package and you will get job done.
If you want to create it using BIDS you can go to dataflow task and choose source as excel and destination as flat file and configure the flat file destination to be comma separated value.
I hope this is helpful.
Set your source as Excel and configure the destination as Flat file which points to a CSV file.
Though, I am not sure, just try changing the extension of the file from .xls/.xlsx to .csv
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?