Hello, I'm ABLE to import excel 2007 file, but I am NOT able to LOOP through a container when trying to assign ConnectionString expression. I smiply copy the following code. Does this added "expression" basically overwrites the existing ConnectionString that was created when Excel Connection Manager is created? "Data Source=" + @[User::fullname] + ";Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=Excel 12.0"; @[User::fullname] is the variable assigned in the loop container Can anyone help me? Much Appreciated!

Hello LAWSQL, Why would you loop? be aware that ForEach Loop (or whatever you use) 1 st thing caches the data, so if something changes along the way it will not know/catch up after. Arthur My Blog

Hello, I'm ABLE to import excel 2007 file, but I am NOT able to LOOP through a container when trying to assign ConnectionString expression. I smiply copy the following code. Does this added "expression" basically overwrites the existing ConnectionString that was created when Excel Connection Manager is created? "Data Source=" + @[User::fullname] + ";Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=Excel 12.0"; @[User::fullname] is the variable assigned in the loop container Can anyone help me? Much Appreciated! Here is what I have used in one of SSIS package... In below expression, I have used Double_Quotes as string with constant value = " "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + @[User::fullname] + ";Extended Properties=" + @[User::DOUBLE_QUOTES] + "Excel 12.0;HDR=YES" + @[User::DOUBLE_QUOTES] + ";" You can copy and paste it. Note: There is a property in Excel Connection Manager "RetainSameConnection", please set it to false. Thanks Prasoon