Configure connection String for Excel Source in Expression property
Step 1: Create variable containg excel file name.
Step 2: Go to Excel Data Source Properties, and in expression select Connection string and give expression as like below:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Datafiles\\TestDrive\\Pending\\" + @[User::FileName] + ";Extended Properties=\"EXCEL 8.0;HDR=YES\";"
Step 1: Create variable containg excel file name.
Step 2: Go to Excel Data Source Properties, and in expression select Connection string and give expression as like below:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Datafiles\\TestDrive\\Pending\\" + @[User::FileName] + ";Extended Properties=\"EXCEL 8.0;HDR=YES\";"
No comments:
Post a Comment