October 6, 2009 at 2:03 am
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
Do you have write permission on your c:\ drive? are you able to create files manualy?
October 16, 2012 at 8:45 am
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
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy