December 9, 2008 at 7:02 am
Hi,
I am using ftp task in ssis package to download a file from ftp site and process it, this is working fiine now the client has asked for a ftps instead of ftp 🙁 I searched msdn and could not fiind much info about using ftps in ssis. Searching on internet gives the impression it is not possible with the out of the box tasks available in ssis, instead point to 3rd pary components secureblackbox, rebux, cozyroc etc I am looking for a solution with out the need for installing any dll's on the server as I do not have access to client's server and I sure they will not agree to install any components. Any suggestions, ideas will be highly appreciated.
Regards,
Santhosh
December 9, 2008 at 7:17 am
You can do this with a script task and some VB.Net, but unless you are familiar with .Net development, the script task, and ftps, I would recommend purchasing a 3rd party component for this. They are pretty cheap and it will probably save you a bunch of headaches later.
If the client is asking for ftps, they must have an understanding that this qill require change. Installing a component to do this is pretty simple. You should be able to get them to do this.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply