I am trying to write code to pull information out of SQL/Server, re-format it and put into ESSBASE OLAP Engine.

Requirements include:

That I split: My loads of data (1 million rows per year) with 3 years history into a tab delimited file for loading into Essbase.

Today, I have a column BUS_YEAR_ID that contains the Year to run. I would like to be able to loop through a pull three seperate tab delimited files for each year.

Any help would be appreciated..

Thanks
Greg