May 29, 2012 at 7:41 am
Using the File System Task I was able to take a copy of an exel file and paste it into a different folder, now I need to convert the excel file into a .csv file.
Thanks
May 29, 2012 at 8:30 am
You can either use .NET to do that, by creating an Excel object and calling the Save As method, or you can use a data flow from the Excel file to a Flat File destination set up as a csv file. I recommend the data flow method.
If you use the data flow:
Set up the Excel file as the data source (you'll need to set the connection to have a variable file path with the file name you need)
Set up a csv file as the data destination
Run as usual
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply