Migrating document in ssis

Question

Viewing 4 posts - 1 through 3 (of 3 total)

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

pduplessis-723389 SSChampion Points: 10599 More actions · Answer 1

Hey,

My problem with the FTP task is that it is not very dynamic with the more intense stuff.

For example, I have to FTP files from server a to server b every day, but I only have to FTP the items not FTP'd before.

Also, once I have FTP'd the file, I have to rename it to a different directory.

The FTP task simply did not allow for this flexibility.

However, in saying that, if it is a more straightforward thing such as transferring x amount of files from source to destination, it will suffice.

Please be more specific as to what you want to do during your FTP task

~PD

Venkatesan Prabu SSCommitted Points: 1892 More actions · Answer 2

I am new to ssis and wish to know the steps to proceed this.

I need to transfer the files from source FTP to destination FTP without any transformation thats it. But i need procedure to achieve this.

Thanks and Regards,
Venkatesan Prabu, 😛
My Blog:

http://venkattechnicalblog.blogspot.com/

pduplessis-723389 SSChampion Points: 10599 More actions · Answer 3

Hey,

The FTP task should allow you to do this quite effectively.

a) Create a FTP connection in your connection manager. This is for your source FTP site

Specify the userid etc that you are using to make the FTP connection

b) Create a FTP task on your control flow

On the FTPconnection, point this to your FTP connection you created in step a

On the file transfer section, do the ffg

Specify the remote path (this is the path where your files are located)

Specify if you want to overwrite the files at the destination

Specify the local path where you are transferring the files to (i.e. on your sql server this will be the FTP path that you are transferring files to)

Specify the operation that you want to complete (in this case, you want to receive files)

TADA

All files that you are found on your remote path will be transferred to the local FTP path

Trust this helps

~PD