Hello Team - How do I move files from Folder A to Folder B and Folder C through the SQL query?
SQL Version: 2014
Folder A: C:\FTP\Main\FolderA
Folder B: C:\Staging\Local\FolderB
Folder C: C:\Staging\Local\FolderC
Folder A is the main path where I get the files from clients on daily basis.
I need to move files from Folder A to two folders (Folder B and Folder C)
How do I write this in SQL and want to put this in SQL stored procedure so I can schedule it to run daily in SQL Agent?
I don't have an option to do it through VS filesystem task.
Thanks in advance for your help.

