SQLServerCentral / SQL Server 2005 / SQL Server 2005 Integration Services / Excel Connection string - Dynamic string / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 22:36:46 GMT20RE: Excel Connection string - Dynamic stringhttp://www.sqlservercentral.com/Forums/Topic1233063-148-1.aspxAnd setting it as an Expression, not directly as a property.Wed, 11 Jan 2012 14:14:30 GMTPhil ParkinRE: Excel Connection string - Dynamic stringhttp://www.sqlservercentral.com/Forums/Topic1233063-148-1.aspxNever seen that error. Did you try using the ExcelFilePath property instead of the ConnectionString property? And also setting DelayValidation to true?Wed, 11 Jan 2012 13:57:33 GMTkramaswamyExcel Connection string - Dynamic stringhttp://www.sqlservercentral.com/Forums/Topic1233063-148-1.aspxHi All,when i am trying to give the connection string as dynamic for excel as below:"Provider=Microsoft.ACE.OLEDB.12.0;Data Source="+ @[User::FilePath] +";Extended Properties=\"" + "Excel 12.0;HDR=YES" + "\""+";"i am getting the error:please check the attached [b]untitled.bmp[/b]Tue, 10 Jan 2012 04:53:53 GMTSQL*