I use Visual Studio 2015
and SQL Server 2016
and also I use COZYROC component for SSIS for working with SFTP.
I what move all files between two folder in SFTP. For that. I have created a variable (V_FilesNameList) with object data type. Then, I have used a COZYROC SFTP Task
for getting the list of files name on SFTP server:
This is a configuration for above component :
Then, I have created a foreach loop on my variable (V_FilesNameList). And inside the loop I want to change the name of each file and copy it to the new address.
But I have this error :
Error: ForEach Variable Mapping number 1 to variable
"User::V_File_Name_Old" cannot be applied.
Error: ForEach Variable Mapping number 919997528
to variable "껤ʧ" cannot be applied.
And when I want to watch the value inside the my variable (V_FilesNameList) in Watch windows, I have this error :
V_FilesNameList Unable to evaluate the expression. An error occurred
that usually indicates a corrupt installation (code 0x80004002).
If the problem persists, repair your Visual Studio installation via
'Add or Remove Programs' in Control Panel.
Why I have those errors? And how can I move the files between two folder in SFTP server with SSIS?
And how can I move the files between two folder in SFTP server with SSIS?
Check the Variable Mappings
in your foreach loop container
, if the object V_FilesNameList
contains a list string of file names, then the variable in your Variable Mappings
should be in string
data type, so that they could be mapped correctly. I am guessing your mapped variable variable 껤ʧ
is not set correctly.
I had the error to variable "껤ʧ" cannot be applied
when I was working with a ForEach loop container too. The problem is with NULL's in the ResultVariable. Try to handle the NULLS returned from source. In my case, the object variable was populated from a query so all I had to do was use ISNULL sql function.
User contributions licensed under CC BY-SA 3.0