import issue..plz urgent

• Chinna

  SSCertifiable

  Points: 5408

  More actions

  March 10, 2008 at 12:14 pm

  #182996

  hi i am importing an excel file into a db using import export wizard in ssis ...i created a package when i run the package i get an error in data flow task as

  [Source - Query1$ [1]] Error: The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009.

  [DTS.Pipeline] Error: component "Source - Query1$" (1) failed validation and returned error code 0xC020801C.

  [Connection manager "Excel Connection Manager"] Error: An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".

  these were my error and moreover i have 4 columns in my excel spread sheet but when i jus add it to my source it show 6 columns such as

  name,id,type,location,f5,f6

  so f5,f6 are the new one which it shows is the probem occured due the extra columns and why did the extra columns show up....

  so could u plz help me out a bit urgent thkz in advacne...

  Thanks,
  Chinna

  Its the Journey which gives you Happiness not the Destination-- Dan Millman

• DiverKas

  SSCrazy

  Points: 2049

  More actions

  March 10, 2008 at 1:39 pm

  #787563

  You get the extra fields if there is data SOMEWHERE in the sheet in the 5th and/or 6th columns. F5 and F6 are default names if none are provided.

  This includes spaces, comments etc. Anything in the extra columns will trigger it to send them up.