Save MS Excel into .CSV format
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 29th, 2012 9:44am

If you want to do it using SSIS then set up an Excel source and a flatfile destination - comma delimited.Chuck Pedretti | Magenic North Region | magenic.com
Free Windows Admin Tool Kit Click here and download it now
May 29th, 2012 9:48am

Dataflow task with excel as source and flat file as destination... or a Script Task.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter
May 29th, 2012 9:48am

There should not be such a need because SSIS can process Excel files. So use the Excel source: http://msdn.microsoft.com/en-us/library/ms139836.aspxArthur My Blog
Free Windows Admin Tool Kit Click here and download it now
May 29th, 2012 9:49am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics