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 |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2005-11-17 : 21:14:34
|
| Hi,We have an application that has an upload function. The way the upload function works is that the ASP script calls a stored procedure which in turns executes a DTS package to extract the data from the uploaded file to a database table. The package runs fine. But apparently the stored procedure that calls it only runs mid way. This is error I get when the web page tries to load. From the error below, you can see the line "*** Package object Created Successfully". This line comes from within the stored procedure sp_ExecutePKG, which is called from within sp_DTSRun. Beyond that line, I believe sp_ExecutePKG stops running. Error Type:Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)[Microsoft][ODBC SQL Server Driver][SQL Server]*** Package object Created Successfully/employee/Reports/Upload_Action.asp, line 65Here's the error I got from running sp_DTSRun*** Package object Created Successfully*** LoadFromSQLServer failedOLE Automation Error Information HRESULT: 0x80004005 sp_OAGetErrorInfo failed.The package is created on a named instance ( not default )of SQL server 2000 with SP4. Any help in this regard would be of great assistance to me. Thank you. |
|
|
|
|
|
DTS Error ...Pl. help.