Sorry, I missed this is behavior by design.
But it is killing me. I can dynamically create a file but when I try to use an expression as an attachment in the FTP Task it bombs out on me.
Thanks,
Kent
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/