An OLE DB record is available. Source: "Microsoft Office Access Database Engine" Hresult: 0x80004005 Description: "Failure creating file.".

• karlo_cor

  SSC Veteran

  Points: 211

  More actions

  October 6, 2009 at 2:03 am

  #136327

  Hi Everyone,

  I need urgent help on this one.

  I am running an SSIS package for 32 bit on a 64 bit server. The packages imports data from an excel file on a Network Drive (UNC).

  SCRIPT:

  EXEC xp_cmdshell 'C:\"Program Files (x86)\Microsoft SQL Server"\90\DTS\Binn\dtexec.exe /F "C:\a.xls"'

  ERROR:

  SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

  An OLE DB record is available. Source: "Microsoft Office Access Database Engine" Hresult: 0x80004005 Description: "Failure creating file."

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  October 6, 2009 at 3:55 am

  #1062150

  Do you have write permission on your c:\ drive? are you able to create files manualy?

• aepc.-

  SSC Enthusiast

  Points: 141

  More actions

  October 16, 2012 at 8:45 am

  #1549613

  I'm getting that error when the package has to create a new excel file to export SQL data on it, the weird thing is when it create the file with a constant name works fine, but when I set an expression the error appears.

  The expression that I was talking is the following:

  ExceExcelFilePath[User::OrgDirPath]+ @[User::ExcFile] + SUBSTRING( (DT_STR,30,1252) GETDATE(), 1, 21 ) + ".xls"

  I want to create a new file with date, OrgDirPath have the path location and ExcFile the name that I want to set.

  I wait for your comments,

  Thanks & Best Regards,

  Alex.

• herladygeekedness

  SSCertifiable

  Points: 5878

  More actions

  October 18, 2012 at 9:13 am

  #1550547

  Not quite sure what is in your variables, but try using double slashes \\ as there is some weirdness in the way SSIS reads pathing.