Hi,
I have a positional flat file which is > 0.5GB in size.Using the FF wizard the FF was transformed into an XML schema.
The FF has header info.
From the original FF records (having 50 items) we need only 5 items per record. Hence a transform was done to collect and calculate only the neccessary items.
This is then loaded into the DB using bulkinsert.
All this works fine when the size of the file is small.
When it is > 1.5MB the system errors out.
What is the best approach to process large flat files ?
What are settings in Biztalk that i need to be aware of for processing these large files ?
Any good articles for Biztalk 2006 ?
-Jerry