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 |
|
william_lee78
Yak Posting Veteran
53 Posts |
 Posted - 2004-10-04 : 08:08:41
|
| Hi, I have created a DTS package to transfer data from SQL 2000 to MS Access and MS Excel. Now, I would like to add some error handling in my package basically to report any error to user. I need to log the error in Windows application log or SQL 2000 so that the user can click and check is there any error occur.Can someone to teach how to do this? I'm new with DTS.Thank you. |
|
|
Shurgenz
Yak Posting Veteran
51 Posts |
Posted - 2004-10-05 : 07:58:20
|
| see DTSTransformPhaseInfo Object in BOL |
 |
|
|
|
|
|
Error Handling