I am using sql query as the source of a Data Driven Query Task. I want to
generate this query in an activex script task and set. but i couldn't find
this property of the object.

thanks

isn't there reference for DTS task objects. i can't find in msdn..does ms
think that we are some kind of astrologer?


"Yener" <someone (AT) com (DOT) com> wrote

You can find it on a Google search but by far the easiest method is to
look in Books Online that comes with SQL Server

Allan

"Yener" <someone (AT) com (DOT) com> wrote

Allan, yes i did google search , i looked the BOL also. But i was only able
to find Darren Green's following article.
http://www.databasejournal.com/featu...le.php/1461501
In this article , he tells the properties of a Custom Task of Execute SQL
Task,
as an example. i need the same for Data Driven Query Task. Source of this
task is an sql query. i want to form this query with activex script and
then set it as the source. but no way! i cant find the properties of
DTSDataDrivenQueryTask.
i am thinking some other solutions now. maybe i can fill a temp table with
an execute sql task ( the article above explains how to set SqlDescription
of An Execute SQL Task) , then set this temp_table as the source of Data
Driven Query Task.






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

Are you not looking for the SourceSQLStatement if the task? (Custom) ?


"Yener" <someone (AT) com (DOT) com> wrote

The DDQ task is documented in BOL-

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\dtsprog.chm::/dtsptasks_26d0.htm

This article shows all the basics, just reference your DDQ task by name
instead.

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com


"Yener" <someone (AT) com (DOT) com> wrote

yes, that is it!
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

thanks Darren, that is what i was looking for!
"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote