Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SFTP not working in SSIS

Posted on 2014-07-25
5
252 Views
Last Modified: 2016-02-11
Hi,

  I'm on BIDS 2008. When i add the FTP task to my local project (on my local machine) and configure it with the server IP, Username and Password and port 21, it works fine without issues.
But when i do the same setup on my server where it is BIDS 2009, i cannot connect with the above credentials. I can however, connect to the remote machine from my server using Filezilla.

Is there a specific setting i might be missing to get the FTP task to work? Please advise.
0
Comment
Question by:pvsbandi
  • 2
  • 2
5 Comments
 
LVL 13

Expert Comment

by:Russell Fox
ID: 40220685
What's the error message? Try setting SSIS package encryption to EncryptSensitiveWithPassword. You might need to add a firewall exception to MsDtsSrvr.exe and/or DTExec.exe. Or a host of other issues - let us know the error message you're getting and we should be able to narrow it down. Also, you should check the windows logs and the source and target machines to see if there's more information there.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 40220706
The FTP task in SSIS does not support SFTP.  As a workaround you will have to use a third party tool.
0
 

Author Comment

by:pvsbandi
ID: 40226315
Thanks. Can we script it?
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 40226647
You can either find a third party tool that supports SFTP (WS_FTP comes to mind here) or you may find some .NET code that does the same.
0
 

Author Closing Comment

by:pvsbandi
ID: 40243590
Thanks! We used Winscp.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
t-sql need help on t-sql 10 25
Re-appearing SQL Server Agent jobs 7 28
Nested Case statement 4 37
Need help in debugging a UDF results 7 16
My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question