November 21, 2007 at 8:44 am
Hi,
I want to move the data from SQL tables to flat files.
a, I want to move the correct data into one flat file and error data into another flat file.
b, I want to log the error details into another flat file. The flat file contains,error occured in the particular row,error occured due to contraint or due to invalid data type.
c, is it possible to do it through design mode without using any script?
Please guide me how can i proceed this.
Regards
Senthil
November 21, 2007 at 8:53 am
The short answer is that it can probably be done without writing any significant code or using a script component.
It will really depend on what you consider bad data and errors. If you post a few sample rows of good and bad data and what you would want to error messaging, it may be possible to give you some direction.
November 21, 2007 at 8:57 am
You could accompish this using a script task in an onError event handler.
Refer to Daniel Read's post here -
http://www.developerdotstar.com/community/node/327
Tommy
Follow @sqlscribeFebruary 7, 2012 at 10:53 am
Hi ,
Please find the below blog where i have updated similar error handling.
http://www.nkannan.com/2012/02/error-handling-in-ssis-dft.html
Thanks,
Kannan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply