Hi Michael,

Thanks for all your help! 🙂

I'm trying your suggestions. I've removed the external process and configued my destination flat file to use a variable which points to the path directory of the file. I then used expressions to create the value (filename) of the connectionstring of my destination connection object. My data flow now works, and it creates the file with name I need. However, I'm still encountering a problem with my FTP task. I'm not sure if I'm doing it right, but I configured the localpath of my FTP task as a variable. I then used the same variable (as the one I used for my destination flat file). Again, I used expression builder to set the localpath property as the variable concatenated with the expression code you gave me. The error this time is:

Error: Failed to lock variable "c:\report\April2008_report.txt" for read access with error 0xC0010001 "The variable cannot be found. This occurs when an attempt is made to retrieve a variable from the Variables collection on a container during execution of the package, and the variable is not there. The variable name may have changed or the variable is not being created.".

I tried creating a new variable in case the error is because the other one is still being referenced by the data flow, but I still get the same result (error). Any ideas? I'm sure there's a simple explanation to this, just can't figure it out myself.