Question how to use column name of table in "file to file" parameter of FileMov action

Hello,

i have one sql table where i store "file name" and "path" of file ,the path are different like bellow


i have created loop maping which is exceuted successfully,


and after exceution of each file i want to move that file in "path" which is store in "File_directory" column of sql table.


so i use sqlOperation to read file_directory for perticular file_name which run successfully . i tested it using sqlexport action .


the issue is in FileMove Action


here i specify 2 parameters
1. file to file= ${~/File_directory}$\${~/p_FILE_NAME}$
2.file from file= D:\Devl\ind\1071_dom_cndr\import_files_system\${~/p_FILE_NAME}$
where ${~/p_FILE_NAME}$ stores "file name" and ${~/File_directory}$ is column name of table which stores file directory.

the process run successfuly but perticular file is remove from that place but didnt move to perticular folder
that is [parameter "file from file" work well but " file to file" parameter not work and also does not display error.

please suggest solution?

Your process is designed with a Bind Link.
In this case, the "File_directory" column which was selected in the SQL Operation can be referenced with expression :{File_directory}:, not with ${~/File_directory}$.

Another possible design is to use a SqlToParameters instead of SqlOperation. In this case you would use a ${paramter}$ and not a :{Bind variable}:

Yes,

Thank you, it works.

Regards,
Nikita Barve.