SSIS Help: Archive a file from the list of files that does not exist in SQL Table -

i create in ssis package, wherein, loop in list of files in directory or folder , check each files if exist in sql queried table. if filename not exist in table, archive in different folder.

thanks advance help! =)

you use each loop container can pointed said directory or folder , store file name (name , extension, qualified or name depending on requirement) in variable eg. loopvariable. use execute sql task inside container has prepared statement - if exists (select * [files] [filename] = ?)select 'yes' else select 'no' - in parameter pass loopvariable , result map variable fileexists. in precedence constraint editor use - expression - [user::fileexists] =="no" , connect file system task moves file archive folder.
note: might need form file path in case not getting qualified name loop container.