 | |
get error message on error in SSIS
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: get error message on error in SSIS -
09-16-2008
, 10:17 AM
|
I, too, have agonized over this one. Use the Expression Editor and look for a variable called [System::Source]. That should contain the name of the offending Task. However, I have to tell you that I have only accessed this variable from withing the Event Handler portion and cannot say for certain that it is available in the regular Control Flow. HTH -- Todd C [If this response was helpful, please indicate by clicking the appropriate answer at the bottom] "parez" wrote: Hi All, I have an an ssis package with a lot of sql tasks. After finishing the first task it goes to the next and so on. All tasks on error (the red line) go to one sql task where I update the status of the request. How do i get the actual error message in the the error Sql task TIA |
and post again.
#12
| |||
| |||
|
|
I, too, have agonized over this one. Use the Expression Editor and look for a variable called [System::Source]. That should contain the name of the offending Task. However, I have to tell you that I have only accessed this variable from withing the Event Handler portion and cannot say for certain that it is available in the regular Control Flow. HTH -- Todd C [If this response was helpful, please indicate by clicking the appropriate answer at the bottom] "parez" wrote: Hi All, I have an an ssis package with a lot of sql tasks. After finishing the first task it goes to the next and so on. All tasks on error (the red line) go to one sql task where I update the status of the request. How do i get the actual error message in the the error Sql task TIA |
and post again.
#13
| |||
| |||
|
|
I, too, have agonized over this one. Use the Expression Editor and look for a variable called [System::Source]. That should contain the name of the offending Task. However, I have to tell you that I have only accessed this variable from withing the Event Handler portion and cannot say for certain that it is available in the regular Control Flow. HTH -- Todd C [If this response was helpful, please indicate by clicking the appropriate answer at the bottom] "parez" wrote: Hi All, I have an an ssis package with a lot of sql tasks. After finishing the first task it goes to the next and so on. All tasks on error (the red line) go to one sql task where I update the status of the request. How do i get the actual error message in the the error Sql task TIA |
and post again.
#14
| |||
| |||
|
|
I, too, have agonized over this one. Use the Expression Editor and look for a variable called [System::Source]. That should contain the name of the offending Task. However, I have to tell you that I have only accessed this variable from withing the Event Handler portion and cannot say for certain that it is available in the regular Control Flow. HTH -- Todd C [If this response was helpful, please indicate by clicking the appropriate answer at the bottom] "parez" wrote: Hi All, I have an an ssis package with a lot of sql tasks. After finishing the first task it goes to the next and so on. All tasks on error (the red line) go to one sql task where I update the status of the request. How do i get the actual error message in the the error Sql task TIA |
and post again.
#15
| |||
| |||
|
|
I, too, have agonized over this one. Use the Expression Editor and look for a variable called [System::Source]. That should contain the name of the offending Task. However, I have to tell you that I have only accessed this variable from withing the Event Handler portion and cannot say for certain that it is available in the regular Control Flow. HTH -- Todd C [If this response was helpful, please indicate by clicking the appropriate answer at the bottom] "parez" wrote: Hi All, I have an an ssis package with a lot of sql tasks. After finishing the first task it goes to the next and so on. All tasks on error (the red line) go to one sql task where I update the status of the request. How do i get the actual error message in the the error Sql task TIA |
and post again.
#16
| |||
| |||
|
|
I, too, have agonized over this one. Use the Expression Editor and look for a variable called [System::Source]. That should contain the name of the offending Task. However, I have to tell you that I have only accessed this variable from withing the Event Handler portion and cannot say for certain that it is available in the regular Control Flow. HTH -- Todd C [If this response was helpful, please indicate by clicking the appropriate answer at the bottom] "parez" wrote: Hi All, I have an an ssis package with a lot of sql tasks. After finishing the first task it goes to the next and so on. All tasks on error (the red line) go to one sql task where I update the status of the request. How do i get the actual error message in the the error Sql task TIA |
and post again.
#17
| |||
| |||
|
|
I, too, have agonized over this one. Use the Expression Editor and look for a variable called [System::Source]. That should contain the name of the offending Task. However, I have to tell you that I have only accessed this variable from withing the Event Handler portion and cannot say for certain that it is available in the regular Control Flow. HTH -- Todd C [If this response was helpful, please indicate by clicking the appropriate answer at the bottom] "parez" wrote: Hi All, I have an an ssis package with a lot of sql tasks. After finishing the first task it goes to the next and so on. All tasks on error (the red line) go to one sql task where I update the status of the request. How do i get the actual error message in the the error Sql task TIA |
and post again.
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.