Post reply

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

  • 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."

  • October 6, 2009 at 3:55 am

    #1062150

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

  • 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.

  • 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.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply