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 |
|
Yukon2005
Starting Member
8 Posts |
 Posted - 2006-02-21 : 02:11:32
|
| When I execute my DTS package using "EXECUTE master..xp_cmdshell 'dtsrun /S {SERVER NAME}/N "{PACKAGE NAME}" /E'", I receive an error message display as follows:DTSRun: Loading...DTSRun: Executing...DTSRun OnStart: DTSStep_DTSActiveScriptTask_2DTSRun OnError: DTSStep_DTSActiveScriptTask_2, Error = -2147220421 (8004043B)Error string: The task reported failure on execution.Error source: Microsoft Data Transformation Services (DTS) PackageHelp file: sqldts80.hlpHelp context: 1100Error Detail Records:Error: -2147220421 (8004043B); Provider Error: 0 (0)Error string: The task reported failure on execution.Error source: Microsoft Data Transformation Services (DTS) PackageHelp file: sqldts80.hlpHelp context: 1100DTSRun OnFinish: DTSStep_DTSActiveScriptTask_2Error: -2147220440 (80040428); Provider Error: 0 (0)Error string: Package failed because Step 'DTSStep_DTSActiveScriptTask_2' failed.Error source: Microsoft Data Transformation Services (DTS) PackageHelp file: sqldts80.hlpHelp context: 700NULLThis doen't mean much to any of the users. How do I display a proper error message? E.g. The path name "{Path Name}" could not be located. or No data could be found to be exported! |
|
|
|
|
|
How to display a custom error message?