Tag: xp_cmdshell

• February 15, 2013

  Store file names and modified dates in a table without a Foreach Loop Task – SQL Server – SSIS

  Last week I received a request from the project manager. I had to improve the performance of an SSIS package that reads a collection of files from a source folder, and then stores their name, extension, location and modified date. The last step is to move each file to a specific folder depending on a…