I need to create a SSIS package that looks at file names in a shared folder and compares it to a filename stored in a SQL table. If the filename in the shared folder = the filename in the SQL table I need it to copy only those files from the shared folder location to another location. What SSIS task components should I be using to make this happen?
Thanks in Advance
Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.