Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2013

    Unanswered: SSIS over the internet secure?

    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?

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 12
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts