A
Andy S.
I'm trying to load an Excel spreadsheet into a SQL table. The trouble with
the spreadsheet is that it has links that prompt the user on whether to
update them or not. I worked around opening the spreadsheet with the Excel
Application object by turning off interactive prompts and passing 0 to the
Open Workbook method.
My problem is that when I schedule a data pump task to be run, I get an
80004005 error that says
Step Error Source: Microsoft JET Database Engine Step Error
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. Step Error code: 80004005 Step Error Help File: Step Error
Help Context ID:5003051
Can anyone help me with this? I was looking at the dynamic properties task
to modify the excel connection, and I see these OLE DB properties called
Mode and Prompt. I just can't figure out what I should those values to.
Incidentally, I'll pass on a tip for DTS. I highly recommend querying
msdb..sysdtssteplog where errorcode > 0 and starttime > today's date to find
errors from applications. It beats waiting forever for the Package Logs
window to come up and display and error.
--
*************************************************
Andy S.
(e-mail address removed)
Please remove "noreply" before replying.
*************************************************
the spreadsheet is that it has links that prompt the user on whether to
update them or not. I worked around opening the spreadsheet with the Excel
Application object by turning off interactive prompts and passing 0 to the
Open Workbook method.
My problem is that when I schedule a data pump task to be run, I get an
80004005 error that says
Step Error Source: Microsoft JET Database Engine Step Error
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. Step Error code: 80004005 Step Error Help File: Step Error
Help Context ID:5003051
Can anyone help me with this? I was looking at the dynamic properties task
to modify the excel connection, and I see these OLE DB properties called
Mode and Prompt. I just can't figure out what I should those values to.
Incidentally, I'll pass on a tip for DTS. I highly recommend querying
msdb..sysdtssteplog where errorcode > 0 and starttime > today's date to find
errors from applications. It beats waiting forever for the Package Logs
window to come up and display and error.
--
*************************************************
Andy S.
(e-mail address removed)
Please remove "noreply" before replying.
*************************************************