mirsam (3/21/2014)
HiI 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.