processing excel files dynamically using For each and excel source...

• reach.tharan

  SSC Rookie

  Points: 26

  More actions

  February 23, 2012 at 7:56 am

  #268702

  I have an requirement to process the excel file from the specified path, at a time only one file available in that path.

  Have to get the the file with name and processed into SQL datasource, I am using For each loop container and dataflow task on the control flow and using excel source, data conversion and oledb destination on the data flow task.

  In the excel connection manager i am configured path and file using expression.

  But i am getting error as

  Error:SSIS Error code DTS_E_OledbError. An oleDb error has occured, Error code . An oledb record is available. Source : " Microsoft JET database engine could not find the object 'Sheet1$'.

  Make sure the objects exists and that you spel its name and path name correctly.

  I have googled for this and done most the suggestion posted on the blog but still it not working.

  Please help on this already one whole day i have spent on this.

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  February 24, 2012 at 12:14 am

  #1451194

  Are you running in 32-bit mode?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP