Hi,
We are having a simple package which will read a deliminated flat file and put in to a database table.
Now I'm having few concerns on this.
1. Can we validate the structure of the flat file for invalid record, by validating I mean if my flat file is having two fields 1st int and 2nd string like below
1,abc
2,bcd
3,cde
.......
In the same format lets suppose one of the records in between id like
5
6, rtz
.......
In my package this scenario is failing which is correct but if my flat file looks like....
1,abc
2,bcd
3,cde
5,def
6
Than my package is not failing and rejecting that last invalid records with warning "[Flat File Source - Role Data [1]] Warning: There is a partial row at the end of the file. "
i.e. if the invalid record is in between then the package is failing with some flat file validation errors but if it's at the end of the file it's not failing.
Anybody having any idea.
Ram