I have a simple package which uses a multiple flat file connection manager to read around 7 text files ( Total size 40 GB).
I was interested in calculating the speed of the source .So the package has a flat file source with rowcount . The first time when i ran the package , it read around 45 M rows in 9 Mins. which was more then i expected.
But , the next time it was run , prob after an hour or so, it does nt read more then 20K rows\sec.. I cant figure out the problem here.
View Complete Post