move files based on files size

Question

Hi All,

The ssis package I created extracts data from some tables and save them in a destination folder as text files.

I have included File Rroperty task to get file size. File size is passed into a variable.

Now I want to move some files into a different folder based on the files size.

as an example if the file size is > 15 mb i wanna move that to a different folder.

can we do that using file system task.

Thanks

---

shamen

Answer 1

One way would be to use precedence constraints.  You get the file size into a variable, test the variable in the precedence constraint to determine which File System Task to call.  http://msdn.microsoft.com/en-us/library/ms140153.aspx

Personally, I would prefer to use a Script task.

---

Russel Loski, MCT

Answer 2

You would need to move each file in a loop (http://consultingblogs.emc.com/jamiethomson/archive/2005/05/30/SSIS_3A00_-Enumerating-files-in-a-Foreach-loop.aspx)

---

Russel Loski, MCT