FTP TASK in SSIS

Question

FTP TASK in SSIS

nalin_abeywardana

SSC Rookie

Points: 43
More actions
December 18, 2008 at 3:40 am

#155035

Hello There,
I'm new to SSIS and i want to run a FTP task in SSIS.Basically I want to transfer some zip files from a FTP server and unzip them and load data to SQL Sever database.Do any one of you can help me on this or direct me to any supportive documention?
This could be a great relief for me!
Nalin

Viewing 8 posts - 1 through 7 (of 7 total)

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

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

nalin_abeywardana (12/18/2008)
Hello There,
I'm new to SSIS and i want to run a FTP task in SSIS.Basically I want to transfer some zip files from a FTP server and unzip them and load data to SQL Sever database.Do any one of you can help me on this or direct me to any supportive documention?
This could be a great relief for me!
Nalin

Nalin,

You can accomplish this. However you have to start familiarize yourself with SSIS. Check the SSIS samples here.

The FTP functionality can be accomplished with the standard FTP Task. However the standard FTP Task is not secure. Check SFTP Task for secure FTP Task.

There is no easy unzipping available in the out-of-the-box SSIS. Check the Zip Task for unzipping.

For the loading of data you have to use the DataFlow Task. This is where you design your transformation process.

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

nalin_abeywardana SSC Rookie Points: 43 More actions · Answer 2

Hi,

Thank you very much for the response.I'll start looking at these and come back for further help!

Thanks!

nalin_abeywardana SSC Rookie Points: 43 More actions · Answer 3

Hi,

I am using SQL Server 2005 Integration services.I cannot fin any SFTP Task or UnZIP Task on the Control Task tool bar........?

Colud you please explain

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

You have to install SSIS+ library. It is available for download here.

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

nalin_abeywardana SSC Rookie Points: 43 More actions · Answer 5

nalin_abeywardana

SSC Rookie

Points: 43

December 18, 2008 at 9:26 am

#914667

Hi,

Thank you very much..

I'll try on this

Mukti SSCrazy Points: 2826 More actions · Answer 6

You would need licenced version of Cozyroc to deploy on your servers.

nalin_abeywardana SSC Rookie Points: 43 More actions · Answer 7

Hi There,

Thanks for the information.

I'll keep in touch...