secure SSIS Connection

• peacesells

  SSCrazy

  Points: 2882

  More actions

  September 24, 2013 at 3:40 pm

  #299136

  I am working on a SSIS ETL project where I need to transfer data between two different networks-one has its own DMZ. So the data will travel through internet. Both servers are encrypted and secure. I have two concerns here:

  How do I establish/configure a connection between these two servers that are completely in different networks?

  Also the data in flight needs to be encrypted or in other words need to have encrypted or the connection between the two servers need to be connected- how do I accomplish that?

  Thanks.

• michal.lisinski

  SSCertifiable

  Points: 6933

  More actions

  September 24, 2013 at 4:39 pm

  #1652919

  Hi Peacesells

  To avoid network problems SSIS extracts data to flat files on first server and put on sftp, then next server transfer and

  load to DB. Imho it's not the fastest method but very stable.

  Br.

  Mike