Expressions on the Properties of a File Connection
I used an expression for the connection string of a File Connection.
I evaluted the expression and verified that it was correct.
I found that the package ran successfully (interactively or scheduled by SQL Agent) but the No file was ever created.
However if I removed the expression and hardcoded the Connection String, the package ran successfully (interactively or scheduled by SQL Agent) and the file would be created and log entries would appear.
Has anyone experienced this behaviour with SQL 2005 sp1.
Thanks

