GSquared, thanks for the reply. I created a variable that is the entire Path. I created an expression that uses the variable plus the datetime, very similar to...

Thanks everyone,

So I've gone the SSIS route. I have it working. I want to implement ftp'ing the file now. I've seen a couple posts on how to do...