Hi,

I am a new user to DTS. I have worked in VB 6.0 to connect to Oracle
before.

I'm now trying to get some stuff done using DTS. I've been
experiencing trouble connecting to an SQL server , querying it, and
using the results in an ActiveX script coded in VBScript.
I'm stuck in my old ADODB style of coding where I create a connection
object and use it.

It doesnt seem to work here. Ive read several posts and checked out
www.sqldts.com but i've not been able to put the pieces together.(udl,
connection, task - all terms used in dts).

So can someone please give me the following:
guidelines on how to do a connect to sql server, query and use the
queried data in DTS.
Sample code would be of immense help.
I can also be reached at gurumum (AT) ececs (DOT) uc.edu

Please help ASAP, my JOB IS ON THE LINE!

You could if you really wanted read the results of a query into a Global Variable Rowset and then use ADO type code to get at what
you need. I would try to avoid this as you may/should be able to use DTS with no ADO code internally.


Have a look at this article

How to loop through a global variable Rowset
(http://www.sqldts.com/default.aspx?298)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Madhusudhan" <gurumum (AT) email (DOT) uc.edu> wrote

You could if you really wanted read the results of a query into a Global Variable Rowset and then use ADO type code to get at what
you need. I would try to avoid this as you may/should be able to use DTS with no ADO code internally.


Have a look at this article

How to loop through a global variable Rowset
(http://www.sqldts.com/default.aspx?298)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Madhusudhan" <gurumum (AT) email (DOT) uc.edu> wrote

Hi,
Allan, thanks for your help. I'm now beginningto find my feet in DTS.
your site sqldts.com is amazing. Great work!

Thanks again

Madhusudhan

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote