SSIS - FTPS

• atsql

  Right there with Babe

  Points: 740

  More actions

  March 5, 2013 at 1:02 pm

  #271955

  Is there any way to implement FTPS in SSIS SQL 2005 without thirt party tools?

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  March 5, 2013 at 10:55 pm

  #1593768

  You can implement your own transfer using .NET in a Script Task. Here is an article showing how to do it in C#. You'll have to port the code to VB.net since you're using SSIS 2005:

  http://www.codeproject.com/Articles/31624/An-FTP-secure-client-library-for-C

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato