Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
svicky9
Posting Yak Master
232 Posts |
 Posted - 2008-03-05 : 11:11:22
|
| Hi experts When i ran SSIS package from Business Intelligence studio it works fine..but when i use the DTEXEC.EXE /SQL it gives me error at the Data transformation Tasks for Excel DestinationDescription: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data.".I have given the same permissions as the Sql server and Sql server agent to the Folder where the excel file is sitting.Is there anything else i have to add for the package to work?VicVichttp://vicdba.blogspot.com |
|
|
dineshasanka
Yak Posting Veteran
72 Posts |
Posted - 2008-03-05 : 12:02:52
|
| Excel file needs to be closed.---------------------http://dineshasanka.spaces.live.com/ |
 |
|
|
dwthoma
Starting Member
2 Posts |
Posted - 2008-04-22 : 19:16:36
|
| I get the same problem. Yes i closed excel and ensured all openfiles are closed. Maybe the server is heavily fragmented? ??? An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data.". |
|
|
|
dwthoma
Starting Member
2 Posts |
Posted - 2008-04-22 : 19:17:57
|
| maybe the SSIS manager ensures all connections to the file are closed before it executes? |
|
|
|
|
|
|
Excel problem in SSIS