Please try removing your property expression on the Name, and put one on the ConnectionString property only. It will be a more complicated expression, but using the ConnectionString property expression has been observed to be most reliable. Talk to me now on

i have a similar package and I created an expression to update ExcelFilePath property of the connection manager. File name is passed via variable to the package and gets assigned to the ExcelFilePath property http://sqlworkday.blogspot.com/

Thank You All, Todd the ConnectionString Works good Thank You

Good day, I have an Excel 2007 Connection in SSIS 2005 using Microsoft 12.0 OLEDB Driver, this work fiine when one selectes the file within Name. But as everymonth the period in the path of Name property will change, so i added it int the Expression Name Property. But this does not seem to work as the expression does not overwrite the pnew path of the file, it holds the filename selected when creating the connection. Please Assist.