Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  datareader/dataset in activex script

Author  Topic  contec Starting Member 9 Posts Posted - 2006-11-20 : 11:46:11 Hi, I am trying to generate an email containing some values extracted from a SQL table in my DTS package. I assume this is a fairly simple task and am trying to find some examples on how to use datasets or datareaders in a vbscript activex dts task. What I would like to do is run a select statement, get the results of that statement, and print them out in the body of an email which I then send. Any examples/help would be very much appreciated. Thanks