1

I am looking for a way to move files from one folder to another using SSIS.

I have a foreach loop with an empty data flow and a file system task in the foreach loop.

I want to specify a certain number of files to be moved using a variable. Increments of 1000 files at a time.

Please Help

jarlh
  • 42,561
  • 8
  • 45
  • 63
mcom314
  • 33
  • 2
  • Do you just want to move the files without importing them or anything? Or do you want to import them to the DB then move them? – Brad Mar 04 '19 at 14:14
  • The first step to doing this is to open SQL Server Data Tools and try something. – Nick.Mc Mar 04 '19 at 23:12

1 Answers1

0

If you are looking to move files from directories to another one using variables all you need is a Execute File System Task inside a Foreach Loop container of type file enumerator. There are many articles found on the internet that describe the whole process step-by-step.

If want to exclude some directories or files then you should use a Script Task or an Expression Task to apply filter, you can check my answers on:

Hadi
  • 36,233
  • 13
  • 65
  • 124