| talldrink@gmail.com 2006-03-30, 8:27 pm |
| Hello all,
quickly: I want to be able to be able to have a specific task fail, run
a stored procedure to log the error, and then continue processing the
package as if nothing had gone wrong. When it gets to the end, I'd like
the package to act as if it had suceeded.
More detail: I'm working on a somewhat long ETL where most of my data
is coming from a database that has certain constraints so I can count
on the data being a certain way. A couple of pieces of information I'm
getting from user controlled exel spredsheets. This is all extra data,
and not necessary for a sucessfull processing of the ETL (if the user
messes up, they just don't get their data in the warehouse) Is there
some way for me to have a data flow that handles the spreadsheet, but
if the file is gone, or the data is bad, then just proceed as if the
data flow never existed?
Any help would be appreciated.
|