title: Script to convert CSV to XLS
body: <p>Have a need to automate conversion of CSV files to XLS. The CSV files (which contain text qualifiers) will be automatically downloaded from a SFTP site and pushed to fixed width files for AS400 integration.  The customer currently has someone manually log into SFTP site, download file(s), open in Excel and save as XLS.  They have no control of original format or naming so the script must be able to convert files regardless of file name and/or number of files.  Am looking to automate the manual process or remove text qualifiers to help manage column mapping discrepancy.  Any advice would be greatly appreciated!</p>
  
  <p>The customer uses SSIS as their development tool.  I apologize if the post is not clear. Am a newbie.  Thanks!</p>