i have ssis project 3 ssis packages, 1 parent package calls other 2 packages based on condition. in parent package have foreach loop container read multiple .csv files location , based on file name 1 of 2 child packages executed , data uploaded tables present in ms sql server 2008. since multiple files read, if of file generates error in the child packages, have log details of error (like filename, error message, row number etc) in custom database table, delete records got uploaded in table , read next file , package should not stop files valid , doesn't generate error when read.
say if file has 100 rows , there problem @ row number 50, need log error details in table, delete rows 1 49 got uploaded in database table , package start executing next file.
how can achieve in ssis?
you have set transactionoption=*required* on foreach loop container , transactionoption=*supported* on control flow items within it. allow transactions rolled if complications happen in child packages. more information on 'transactionoption' property can found @ http://msdn.microsoft.com/en-us/library/ms137690.aspx
custom logging can performed within child packages redirecting error output of destination preferred error destination. however, redirection logging occurs on insertion errors. if wish catch errors occur anywhere in child package, have set 'onerror' event handler or utilize built-in error logging ssis (ssis -> logging..)
Comments
Post a Comment