December 17, 2009 at 9:57 am
Hi All,
I am designed a package for importing a flat file to Table.
i am able to import prope data through this package.
But if file contains errors then how to handle them write it to another file and import the proper data?
December 17, 2009 at 10:55 am
This is not the solution, but something to start with.
In the DataFlow task, select the OLE DB source, Right click and choose edit choose error output and there you have few choices to do decide if there is any error in the rows. Select Redirect row to start with it.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 17, 2009 at 10:57 am
[font="Comic Sans MS"]
You can have a look at here : http://goo.gl/i9FU
[/font]
[font="Comic Sans MS"]--
Sabya[/font]
February 7, 2012 at 10:54 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply