Viewing 7 posts - 1 through 7 (of 7 total)
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...
April 12, 2011 at 10:11 am
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!
November 13, 2009 at 11:53 am
I have a similar issue. 'Reference Values' table comprising (amongst its 27 fields)
RFVDM_CODE (Reference Type),
Main)Code, Start_DTTM, End_DTTM, etc.
8012 rows, 830 Reference Types.
The first thing that I...
July 9, 2009 at 3:23 am
Might I also suggest a:
before and after execution -
for a little more information.
June 5, 2009 at 5:20 am
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,...
May 19, 2009 at 11:43 am
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...
May 14, 2009 at 6:34 am
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 ->...
May 14, 2009 at 6:29 am