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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » An OLE DB record is available. Source:...

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

Rate Topic

Display Mode

Topic Options

Author

Message

karlo_cor

Posted Tuesday, October 06, 2009 2:03 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, July 08, 2012 11:56 PM
Points: 1, Visits: 15

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

Post #798354

steveb.

Posted Tuesday, October 06, 2009 3:55 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 8:56 AM
Points: 2,802, Visits: 7,110

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

Post #798399

aepc.-

Posted Tuesday, October 16, 2012 8:45 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, November 05, 2012 7:55 AM
Points: 2, Visits: 10

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.

Post #1373319

herladygeekedness

Posted Thursday, October 18, 2012 9:13 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 2:43 PM
Points: 250, Visits: 687

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

Post #1374428

« Prev Topic | Next Topic »

Permissions