November 23, 2011 at 12:34 am
Hi,
Greetings!!!
How to eliminate the bad data from a source(Excel) file.
Example: One excel sheet contains 20000 records, In this I want to insert into destination(SQLServer) with good data. But Bad data should capture on another excel file.
How we can do/achive that.
If is there any links are available, please let me know.
Thanks In Advance.
Thanks & Regards
Indher Sarvade
November 23, 2011 at 8:30 am
Here's an article[/url] that talks about how to do it. Be sure to look in the discussion as well because there is a link to a custom component I wrote to help with it as well. The code for the custom component in included in the download.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply