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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  DTS Step errors without using GetExecutionErrorInf

Author  Topic  aparnan Starting Member 1 Post Posted - 2001-02-27 : 12:01:21 The GetExecutionErrorInfo returns meaninful information only when the step (status) is completed. How do we get meaningful errors when the step is unable to complete. The Com Error object does not return any errors. Here is what got logged to the error log ************************************************ Step 'DTSStep_DTSExecuteSQLTask_1' failed Step Error Source: Microsoft OLE DB Provider for SQL Server Step Error Description:Cannot open database requested in login 'Text3'. Login fails. Step Error code: 80004005 Step Error Help File: Step Error Help Context ID:0 ************************************** How can this error be captured in a VB server-side program so that it can be raised to a client.