Changing the Record Count & Array Size

sri_vin · Post by **sri_vin** » Wed Dec 08, 2010 7:35 pm

Hi

We have to change the array size and record count from 2000 to minimum no say 1 for every odbc stage.

Is there is any way we can change them globally?

Your help on this is much appreciated.

Regards
Sriram

ray.wurlod · Post by **ray.wurlod** » Wed Dec 08, 2010 10:01 pm

Export the entire project, edit the DSX file, then import the entire project with "overwriting" set.

sri_vin · Post by **sri_vin** » Thu Dec 09, 2010 10:15 pm

ray.wurlod wrote:Export the entire project, edit the DSX file, then import the entire project with "overwriting" set.

Thanks Ray

How about for the new ones? Is there a place we can change the default settings?

Sriram

SwathiCh · Post by **SwathiCh** » Fri Dec 10, 2010 1:26 pm

Add a new environment variable as ARRAYSIZE in admin and default it to '1'.

And in all new jobs development parameterize the arraysize value with the variable defined above so that when we change value at admin level it will propagate to all jobs.

for the existing jobs I think ray suggsted method will be better.