In speaking with a contact at Microsoft, it looks as though it is a known issue. Do you have SQL2000 to upgrade to?

Jeff,

I have run into this same problem in the past. I don't remember finding a fix for it, except that when I upgraded to SQL 2000, the issue went...

Try and take a stab at it first...post the code you have and we can go from there.

Not sure I fully understand what you're trying to achieve, but have you tried using 'WITH ROLLUP' or 'WITH CUBE' to do your totals/subtotals?

try using a different cursor type and see what happens?

Do you know if the problem is happening during the last step? With 36 different last steps that could occur, sounds like it could be an error in one...

what type of cursor are you using to open the recordset. ReadOnly, ForwardOnly?

When using the above cursor type, it usually returns -1. If you were to use for...

what application are you connecting through?

Full text indexing uses a file called noise.enu. You can edit this file to remove or add noise words.

Check out the article by Jon Winer about full-text indexing tips...

try wrapping your alias in single quotes

i.e.

select sfirstname 'en', slastname from tbl_applicants

where 'en' like 'a%'

When I have done this, I create a batch file to do the ftp. Then reference the file as the win-process in the task (I have never tried to change...

I'm not familiar with the Exchange Global list. Is it a text file?

If so, might be able to parse the file with the file system object in a...

Not sure off hand...what about truncating the log. i.e.(do the insert in a loop, insert a record at a time, truncate that log every iteration through the loop) ...

Not sure I have the answer to your question, but you can write a log file to a specified location from the job once you schedule the DTS package. ...

Andy,

Thanks for you input. I'll test it out. I'll try and write it up as a supplement to this article.