<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
SQL Server 2005 Integration Services
»
Error Handling in SSIS Package
Error Handling in SSIS Package
Rate Topic
Display Mode
Topic Options
Author
Message
senthilkumar.m-555627
senthilkumar.m-555627
Posted Wednesday, November 21, 2007 8:44 AM
Grasshopper
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
Michael Earl-395764
Michael Earl-395764
Posted Wednesday, November 21, 2007 8:53 AM
SSCrazy
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
Tommy Bollhofer
Tommy Bollhofer
Posted Wednesday, November 21, 2007 8:57 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 12:25 PM
Points: 1,148,
Visits: 3,149
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
nakkeeran.kannan
nakkeeran.kannan
Posted Tuesday, February 07, 2012 10:53 AM
Grasshopper
Group: General Forum Members
Last Login: Monday, December 17, 2012 8:07 AM
Points: 13,
Visits: 120
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 »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
