var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
We have a 3rd party company that needs to pull data from one of our SQL servers. They mentioned using we could push the data to them using SSIS. I don't know much about SSIS but will this be secure pushing data like this over the internet?
I bet the answer is a big fat "it depends"
SSIS has many methods of data transfer including the ability to use the FTP protocol and run .NET code. So it depends on which method you chose.
Perhaps you should consider exporting the data in to a flat file, encrypting the file then SFTP'ing the resultant documents to your 3rd party?
This cat can be skinned in many ways.
Home | Blog
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors