Search Results: SFTP

• 
  WinSCP from SSIS - secure FTP transfers

  Intro: Free software - it's always right in everyone's price range and when one gets more out of it than one paid for it - there tends to be contentment. Recently when tasked with transferring some files via sFTP, the author found ( ok - Google found ) Wi

  Author:  KeithHyer     Date: 5/5/2010     Section: Blog

  tags : Secure FTP, SFTP, SSIS, StandardInputVariable, StandardOutputVariable, WinSCP
• 
  Task Factory's Secure FTP Task

  Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugg

  Author:  briankmcdonald     Date: 9/3/2011     Section: Blog

  tags : Brian K McDonald, Secure FTP Task, task factory
• 
  SFTP, Red-Gate, and Logging OH MY!

  First, a plug. No, I don't work for Pragmatic Works, but the SFTP task built into Task Factory was SO easy to use and exactly what I needed. Okay, on to the job! ------------------------------------------- Yes, for some reason, I have the Wizard of Oz in

  Author:  SQLKohai     Date: 12/8/2011     Section: Blog
• 
  This may be a "silly" question - Pragmatic Works Secure FTP component

  I've seen a few people blog about the Pragmatic Works Secure FTP component - and I use it too. My question is this. I developed a solution utilizing the component only to discover when it moved to production that the FTP server to which the file must be s

  Author:  KeithHyer     Date: 10/18/2011     Section: Forum

  tags : FTP, Pragmatic Works Task Factory, SFTP
• 
  London Free Event : Next Generation Data Warehouse

  Microsoft & HP jointly presenting half a day free seminar on "Next Generation Data Warehouse" in London on 7th June 2011. Register Today

  Author:  meganathank     Date: 5/5/2011     Section: Blog

  tags : Datawarehouse, London, Free Event
• 
  Task Factory Secure FTP Task

  With Security standards in place today, it is very rare to find businesses that still allow FTP without some sort of encryption requirement. Unfortunately, the Native FTP Task within BIDS doesn’t have any support for SSL/SFTP/SSH etc. If you plan to use S

  Author:  DonnyJohns     Date: 3/15/2011     Section: Blog

  tags : Secure Encryption FTP SFTP SSH SSL TLS SSIS
• 
  What to do? A Best Practices query about file downloads

  Okay, I'm back to where I started, but I don't want to just copy what I am using already because I'm not sure I'm doing the right thing. I go check the SFTP for anything and I download the file if it's there to a directory on one of our fileservers. I loo

  Author:  SQLKohai     Date: 1/10/2012     Section: Blog
• 
  SSIS SFTP Task Factory problem

  I have a directory I need to get to (which I can using the SFTP Task thank goodness), but I am running into an issue. I'm grabbing Red-Gate SQL Backup log files that I have to apply to my db, but I have to apply them in order. I have an SFTP task to get t

  Author:  SQLKohai     Date: 9/20/2011     Section: Forum
• 
  This may be a "silly" question - Pragmatic Works Secure FTP component

  There is not. You would use the native ftp task instead. The Task Factory task is created for sftp only. It filled a need for SFTP, but did not retain ftp most likely because it would be redundant. However, this does not mean it will not in a future relea

  Author:  ogonzalez     Date: 10/18/2011     Section: Forum
• 
  AES 256 Encryption on Files

  Thanks for the information @sqlChicken. I will still be picking up the task factory for the sftp ability amongst others. But the pgp is declared to be not enough by compliance. I will probably try out the gnupg or will attempt to use this microsoft aes cl

  Author:  MattDayton     Date: 7/27/2011     Section: Forum
• 
  This may be a "silly" question - Pragmatic Works Secure FTP component

  Chris / ogonzalaz, Thank you both for your replies - I was suspecting that was the case, but you know how programmers are - sometimes they slip in a "I was debuggind and I left the code in so that it will also..." Chris - One thing I would suggest to make

  Author:  KeithHyer     Date: 10/19/2011     Section: Forum

  tags : FTP, Pragmatic Works Task Factory, SFTP
• 
  Copy a folder from FTP to local/shared drive

  Here is a tutorial to help you out with FTP task. By your description, your control flow will be something similar to: 1) create variable with the path from FTP 2) add a FTP and a Foreach Loop so you can loop in all .csv files from that path. here is a li

  Author:  marcoadf     Date: 3/5/2012     Section: Forum

  tags : container, files, foreach, FTP, loop, rar, SFTP, winrar, zip
• 
  How to decrypt files using SSIS?

  Look on CodePlex. There is a task that can encrypt, decrypt, zip, unzip, and do SFTP. Check the software requirements though, I believe they are pretty high.

  Author:  Daniel     Date: 11/2/2012     Section: Forum
• 
  Advanced Execute Process Task - Video?

  I'm looking for a video demonstration of the Advanced Execute Process Task. I plan to use it for and FTP operation downloading a file from a mainframe. I would like to avoid using a script task for that solution if possible. Below is what I would type int

  Author:  vlaforce2002     Date: 6 hours ago     Section: Forum
• 
  Using Delay Scripts to Strategically Fire SSIS Components

  Using the FTP task or better yet the Task Factory SFTP task you can upload multiple files at one time. The problem you will face is that if all of those files fire at once the package will fail because the server needs to negotiate the transfer. How to so

  Author:  ogonzalez     Date: 9/20/2011     Section: Blog
• 
  SSIS compatibility with Bitvise Tunnelier - secure FTP transfers

  Keith Hyer had a great post which was directed toward using SSIS in conjunction with WinSCP. I am new to SSIS, but I have made several attempts at adapting his approach to work with Bitvise Tunnelier. Each attempt has been flawed and failure is my constan

  Author:  a373769     Date: 3/10/2011     Section: Forum

  tags : Bitvise, Bitvise Tunnelier, FTP, SFTP, Tunnelier
• 
  SSIS compatibility with Bitvise Tunnelier - secure FTP transfers

  The only way i've done SFTP in the past has been with 3rd party components. Here's one you can download http://pragmaticworks.com/products/Business-Intelligence/TaskFactory/Default.aspx .

  Author:  DevinKnight     Date: 3/11/2011     Section: Forum

  tags : SSIS