Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error Handling in SSIS Package Expand / Collapse
Author
Message
Posted Wednesday, November 21, 2007 8:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 09, 2009 2:29 AM
Points: 11, Visits: 84
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





Post #424640
Posted Wednesday, November 21, 2007 8:53 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,732, Visits: 23,078
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.
Post #424645
Posted Wednesday, November 21, 2007 8:57 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 4:45 PM
Points: 1,157, Visits: 3,247
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

Post #424648
Posted Tuesday, February 07, 2012 10:53 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 24, 2014 3:56 AM
Points: 13, Visits: 129
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
Post #1248348
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse