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 |
|
tybaltzeke
Starting Member
28 Posts |
 Posted - 2009-05-01 : 09:42:16
|
| i am deliberately generating an error in a child package called by a parent by passing in a bad connection string through package configurations, which should be triggering an OLE DB error in the source query. i have maxerror set to 1000 in the parent to force ssis to continue processing past the error. i have forceexecutionresult in the child set to none i have VB debugging msgbox scripts set up in both the parent and the child. The script only fires in the parent. How can i access (script, sendmail) to the name of the child package that was just called? Even better, how can i get the child package (where the error is occuring) to fire the onerror email? than i would have the package name |
|
|
|
|
|
help w how to get child package name onerror