1

I am trying to download a .xlsx excel file from FTP server and save it in a .csv file format. I was able to download a file from server using ftp task in SSIS and save it in a local folder now I want to save that file as csv file format for import process. I could not find a conversion method or task from .xlxs to csv. i tried script task but it didn't work. can someone please help.

Hadi
  • 36,233
  • 13
  • 65
  • 124
tanay
  • 27
  • 1
  • 1
  • 7
  • Please be more specific - what did you do in your script task, and what happened? "It didn't work" isn't much to go on. – Brian May 01 '18 at 20:21

2 Answers2

2

The simplest way to do that will be to use an Excel source and a Flat File Destination (set it as a CSV). Hope it helps.

DEEPAK LAKHOTIA
  • 993
  • 5
  • 10
  • SSIS Excel source doesnt accept .xlsx file format so cant do that – tanay May 02 '18 at 14:53
  • It does support. For your quick reference: https://dataintegrity.wordpress.com/2009/10/16/xlsx/ – DEEPAK LAKHOTIA May 02 '18 at 14:56
  • @tanay which version of ssis you are using? – Hadi May 02 '18 at 20:16
  • hi i am using sql server data tool 14.0.61712.050 and its not working as i can not see the option for choosing odbc 12.o driver.i can see the jet driver but not MS office 12.0 odbc driver as shown in the exaple @deepak lakhotia provided. – tanay May 07 '18 at 17:48
  • I'm not sure this will help with the most used case for this question. Excel misinterpreting data types. – KeithL Jul 10 '19 at 14:03
1

You can add a Script task to achieve this, and inside the script you can use Interop Library:

Hadi
  • 36,233
  • 13
  • 65
  • 124