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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy