March 11, 2008 at 8:51 pm
i am importing from flat file to a db in whic i have 93500 rows in which i have some partial rows and inavalid rows which i just want to redirect it to flat file destination......so i have jus added the source and data conversion and oledb destiunation so where should i give the flat file destiantion from which task should i give that ....i tried giving it from oledb destination when i tried to do that it imports 94014 rows but it does not redirect error rows to flat file ...what happened to error rows....so i jus want to know the rows which makes the error...so could plz suggest me ....what i gave is redirect row on all of the tasks for flatfilesource,dataconversion and oledb destination to flat file destination....if anyone done withthis plz let me knoe a bit urget i tried dng that but couldnt solve it ....to be more specific
name,id,location
"abc",1,"ny"
"def",2,"ca"
"ahs",3"WA"
"asc",
"asa",5,"DC
"sad",6"va"
"asa",7,"ia
if this is the source in the flat file with comma delimited and text qualifier is " then i jus the want the ouput in the oledb destination is the rows with 1,2,3,5 and 4,6,7 to flat file destination as it has error in the row...
like 4th row is partial
5th row doesnt have comma in between so doenst have last column
7th row doesnt have text qualifier completely
so i jus want the data whioch is correct to be imported and the others should be imported to flatfile destination could anyone explain me ....plz even tell me where should i mention redirect row in all taks or particular tasks let me know ....
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
June 5, 2008 at 12:03 pm
I'm having the same exact problem! I suspect that this is a bug, but I'm not sure.
Did you ever figure out what happening to the bad rows?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply