SFTP, encrypt or compress data files in SSIS using custom components

Question

Post reply

SFTP, encrypt or compress data files in SSIS using custom components

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

lv42daze100 SSC Rookie Points: 31 More actions · Answer 1

Thanks for the reply. My SQL and VS2008 version information.

Maybe you could suppress the version check during install or something?

Thanks

Paul Horstink Grasshopper Points: 20 More actions · Answer 2

Same error was discussed on the codeplex-page at http://ssisextensions.codeplex.com/discussions/434570, see the reply from mcpunjabi on Thu at 4:22 PM.

I downloaded that link, and it installed without issues, even Toolbox was updated automagically!

lv42daze100 SSC Rookie Points: 31 More actions · Answer 3

lv42daze100

SSC Rookie

Points: 31

March 17, 2014 at 9:10 am

#1697684

That resolved the issue for me, thanks.

eyespi20 Say Hey Kid Points: 711 More actions · Answer 4

When attempting to install the task for SSIS 2010, I encountered a problem in that it said I need to have SSIS 2010 on my system (I did). In researching the solution, the link quoted in the article referred me to the following download https://ssisextensions.codeplex.com/downloads/get/807818 for this tool.

Installing that download and re-launching SSIS 2010 had the task already in the toolbox ready for use without having to add it.

Thanks!

mirsam Grasshopper Points: 12 More actions · Answer 5

Hi

I am very new to the sql and creating SSIS package. I am trying to import data with sftp from vendor's website. The settings works fine with other sftp software but when I try to execute the package, it comes with the following error. I have inserted all the following parameters but it is not working! help!

TITLE: Package Validation Error

------------------------------

Package Validation Error

------------------------------

ADDITIONAL INFORMATION:

Error at SFTP Task: Missing: Host Name, Port Number, User Name, Password, Local File, Remote File.

Error at SFTP Task: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)

------------------------------

BUTTONS:

OK

------------------------------

Stan Kulp-439977 SSChampion Points: 10062 More actions · Answer 6

mirsam (3/21/2014)
Hi
I am very new to the sql and creating SSIS package. I am trying to import data with sftp from vendor's website. The settings works fine with other sftp software but when I try to execute the package, it comes with the following error. I have inserted all the following parameters but it is not working! help!
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at SFTP Task: Missing: Host Name, Port Number, User Name, Password, Local File, Remote File.
Error at SFTP Task: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------

Did you create package variables containing the values for each of those parameters, and select them from the drop-down lists in the configuration page?

I have seen that error, but the only time is when you have no values for the package variables.

The good news is you are really close. You just have to keep playing with it now.