Excel Connection string - Dynamic string

• SQL*

  SSCertifiable

  Points: 6638

  More actions

  January 10, 2012 at 4:53 am

  #248817

  Hi 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 untitled.bmp

  

• kramaswamy

  SSCoach

  Points: 18181

  More actions

  January 11, 2012 at 1:57 pm

  #1432112

  Never seen that error. Did you try using the ExcelFilePath property instead of the ConnectionString property? And also setting DelayValidation to true?

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  January 11, 2012 at 2:14 pm

  #1432131

  And setting it as an Expression, not directly as a property.

  ---