Post reply

Rename .xlsx file to .csv file in ssis 2005

  • January 17, 2013 at 7:20 am

    #268822

    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

  • January 17, 2013 at 8:45 am

    #1578356

    Simply renaming the file won't help much if the xlsx file is truly in Excel format and not simply a CSV file with an xlsx extension. Open the xlsx file in notepad. Is it just a text file? If so then you can use the SSIS File System Task to rename the file to have a csv extension, but you do not need to bother. You can point a Flat File Connection at the file with an xlsx extension. SSIS does not really care about the extension when loading files. It cares that when it accesses it that the contents are in the expected format.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply