no, I did not try sysdtspackages. Is it a straight copy all the data in that table to the new server??? could you elaborate a little?

thanks a lot.

john, thanks so much for the lighting speed response.

i was hoping i did not have to transfer DTS one by one.

thank you very much

it works.

thanks a lot.

We are using an existing design and have no control with it. so re-design the table is out of question. So we have no choice but to accommodate the request....

Chill Remi.

"fix your god damn design". sorry can't do it b/c it is from a big name ERP system which we are using and I do not have control over...

thanks guys/gals.

what if we forget about the excel output format for a monent and say I want to have each data item as a column, instead of a concatenated text...

I am sorry for this confusion. actually concatenate can not be used since we need the columns separate so they can be put in different cell in excel. In another...

many thanks. really appreciated.

i tried refresh before posting the question.

it is gone after closing EM. thanks

 Noel, that is so cool. thanks a lot.

Thanks a lot Frank.

Thanks for the quick response.

It works. ( but I need to comment out the last line, otherwise it gives error about SalesAmount).

It works fine if there are data for the...

Thanks Jonathan.

I changed the data type to decimal and it works fine.