adOpenStatic and adOpenKeyset should help.

The ADO Recordcount property help states

"Use the RecordCount property to find out how many records are in a Recordset

object. The property returns -1 when ADO cannot...

OPENXML in TSQL is the more normal way than using DTS.

You could try using ACTIVEX scripting in DTS and access MSXML as an automation object, (simlar to the way Andy...

just a suggestion for the future. Try running calling DTS from a stored procedure as an automation object. This exposes a rich set of properties and methods which offer far...

Something like

SELECT

newsid,

news_cat,

Count(news_cat)

FROM [tablename]

WHERE logdate BETWEEN '18/06/2002' AND '19/06/2002'

GROUP BY newsid, news_cat

Should do it

I have found it is possible to...

OK I think you might be trying to solve the wrong problem. Firstly the SQL you posted is what SQLServer actually runs so we need to verify that it is...

Jan's method is the one I'd use, however I'd add a proviso that you either make sure you either drop the temporary table or truncate it each time before you...

Hi Vijay

Yup we need some more info. I'm intrigued by your use of the words 'Server Side Cursor'. Are you submitting the SQL to SQLServer via JDBC and asking it...

GUID's is novel, however I bet there's a performance issue. Surely it must be slower to go and get a GUID than increment a number, could be an issue in...

Thanks for that. Now the intersting thing is that you could specify the identity as a bigint according to BOL, however I've got a very strong suspicion that when you...

You might find your answer in Brian Knight's excellent little article 'Locking Down DTS' in this forum

I have found it is possible to please all of the people all of...

By default XML special characters are entitized when mapped from the database, e.g. the '<' character becomes <. Ive used the sql:use-cdata annotation which overides this behaviour. This is a...

Hi Andy

You've got the best advice already. All I can offer is some sympathy. Your use of the word Idiot is very restrained. Hooligan would fit the bill better (before...

I'd be very interested in Antares answer. I'm an old ORACLE hand and though there are many good things in SQL Server there are ommissions, packages apparently being one of...

Could I reccomend calling DTS with the OLE metyhod rather than xp_cmdshell. This offers you far richer pickings in control and error trapping.

I use this little Generic SP to encapsulate...

Like all good politicians I won't answer your question directly. All I'd say is that if you're calling DTS from SP's then I'd reccomend using the OLE object method rather...