Import files directly from FTP to a table

Question

Import files directly from FTP to a table

duanecwilson

Ten Centuries

Points: 1057
More actions
March 16, 2010 at 10:13 am

#386515

Can I use SSIS to import a csv file directly to a table destination? It seems like the FTP task just allows the destination to be a file, which at this point ends up on my local pc and then import it like any other file.
Even when I tried to do that and add a data flow task, it was prompting me for the file name which was not yet in existence on my PC.
I could use some help here. Thank you.

Viewing 6 posts - 1 through 5 (of 5 total)

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

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 1

You need a copy of that file in the location you are going to use it from. It HAS TO EXIST when you do your design work, also be sure to set DelayValidation to TRUE for the dataflow components because when you run it for real, that file won't exist and when it goes to validate the package it will fail. Also, I'm not sure if it was clear, but the FTP task can't be used directly in a Data-Flow, it is a control-flow only task.

CEWII

duanecwilson Ten Centuries Points: 1057 More actions · Answer 2

Thank you for your answer. I did not know anything about the DelayValidation.

So, the bottom line is, I must FTP to a folder first, and then import that file to a table?

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 3

Elliott Whitlow

SSC Guru

Points: 102402

March 16, 2010 at 11:39 am

#1134679

Yes. That is the short answer.

CEWII

Phil Parkin SSC Guru Points: 246979 More actions · Answer 4

... and, to do the design work in the first place, you'll need a valid source-data file in your import folder. Without it, SSIS cannot build the necessary meta data. Once the design is done and DelayValidation is set, you can delete the file.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

COZYROC One Orange Chip Points: 28499 More actions · Answer 5

duanecwilson (3/16/2010)
Can I use SSIS to import a csv file directly to a table destination? It seems like the FTP task just allows the destination to be a file, which at this point ends up on my local pc and then import it like any other file.
Even when I tried to do that and add a data flow task, it was prompting me for the file name which was not yet in existence on my PC.
I could use some help here. Thank you.

Why do you want to import directly from FTP to a table? Is there a specific security-related vulnerability requirement?

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/