Ok, making sense of this as best as I can, it seems that you are processing a comma separated string, into a list (from the table function) and then into...

Well it's a good 5-6 months since I created that script, and it looks as if the project to implement this new software has been delayed until March next year!

Quite...

I have a similar issue. 'Reference Values' table comprising (amongst its 27 fields)

RFVAL_REFNO (ID),

RFVDM_CODE (Reference Type),

Description,

Main)Code, Start_DTTM, End_DTTM, etc.

8012 rows, 830 Reference Types.

The first thing that I...

Might I also suggest a:

time /t

before and after execution -

for a little more information.

Sorry, can't help.

It seems to work on my PC.

I'd suggest an Excel problem. DTS should not be reformatting an excel sheet ... I don't know if it can!!

Unless, of course,...

I had losely related problem with exporting records (using DTS, SQL Server 2000) to access.

Using the 'default' access DB driver, the export took 40-50 mins.

Setting up and using a standard...

Try formatting the Excel cells.

Clearly, the values are correct, and you are requiring a different format.

This would be a formatting issue for whatever application is displaying the results.

Cell Properties ->...