September 24, 2013 at 3:40 pm
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.
September 24, 2013 at 4:39 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy