DTS ActiveX task

From: Chris Kennedy (chrisknospam_at_cybase.co.uk)
Date: 05/26/04 

Date: Wed, 26 May 2004 15:17:37 +0100

I have a task that I want to use a combination of ADO recordsets and TSQL.
How do I, for instance perform a count query, and do some functionality
based on the the result. Ideally I would like to do a count e.g. SELECT
COUNT(idfield) FROM TABLE into a variable and then do some ActiveX
functionality based on the result rather than have to create a recordset
from the query and then pull it into variable. Basically I want to know if
you can combine TSQL and VBScript more easily than on a webpage. Regards,
Chris.

Relevant Pages

  • Re: ActualSize returns -1 for Text fields
    ... > Do you read that field multiple times? ... As I said in my original post, ... query that returned two or more of these fields. ... What exactly do you mean by "I always read ADO recordsets from left to ...
    (microsoft.public.data.ado)
  • Re: ActualSize returns -1 for Text fields
    ... ActualSize of this ... Same is true if I use the query explicitly listing ... first time you read the field ADO will then discard the underlying pointer ... I always read ADO recordsets from left to ...
    (microsoft.public.data.ado)
  • Re: How to View Result Data with SQL Profiler?
    ... > Is it possible to see the result set data returned by a query in SQL ... > I can see the TSQL inside by Stored Procs listed in my trace, ...
    (microsoft.public.sqlserver.programming)
  • View Results With SQL Profiler?
    ... Is it possible to see the result set data returned by a query in SQL ... I can see the TSQL inside by Stored Procs listed in my trace, ...
    (microsoft.public.sqlserver.tools)
  • How to View Result Data with SQL Profiler?
    ... Is it possible to see the result set data returned by a query in SQL ... I can see the TSQL inside by Stored Procs listed in my trace, ...
    (microsoft.public.sqlserver.programming)