Glad to see you're doing your best to make things right.

SELECTRANK () OVER (PARTITION BY br2.brand ORDER BY br2.forecast_percent DESC) rnk,

br2.brand, br2.forecast_percent, br2.territory

FROM ...

Sounds very promising. Looking forward to reading the next level.

The "Move File" operation will not allow you to change the name so the destination can only contain a path to the file folder without the file name. If you...

Here are some screenshots of how I use the File Task.

First I have ForEach loop that will scan a folder looking for files matching a prefix. Here I'm using variables...

Sure, I'll put something together and post it. Thanks for responding.

RonKyle (6/13/2013)

You can actually simplify it even more if you like, by using a File System Task, instead of a Script Task to move your processed files once done. That...