Can you, using a DDQ, execute a given task in a package multiple times? I know that a DDQ allows you to perform *something* dependent on the value of a given field in the DDQ's query rowset, but I don't know if that includes TASKS. Help!

In article <95FDA809-8B1D-4061-9D3A-FCE004F240B1 (AT) microsoft (DOT) com>,
Casualinfoguy <anonymous (AT) discussions (DOT) microsoft.com> writes
In theory you could use the step execute method but this is not
recommended. You can execute SQL, not as a task but as a lookup, but
this can be any SQL you want and doesn't have to return anything.

There are alternatives for driving loops of a resultset, e.g.

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

Workflow
(http://www.sqldts.com/default.aspx?103)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

----- Darren Green wrote: ----

In article <95FDA809-8B1D-4061-9D3A-FCE004F240B1 (AT) microsoft (DOT) com>,
Casualinfoguy <anonymous (AT) discussions (DOT) microsoft.com> write
In theory you could use the step execute method but this is not
recommended. You can execute SQL, not as a task but as a lookup, but
this can be any SQL you want and doesn't have to return anything

There are alternatives for driving loops of a resultset, e.g

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

Workflo
(http://www.sqldts.com/default.aspx?103
--
Darren Green (SQL Server MVP
DTS - http://www.sqldts.co

PASS - the definitive, global community for SQL Server professional
http://www.sqlpass.or

Darren, do you have a telephone number that I could speak to you on, momentarily?

How do you set a global variable to "Dispatch" and what does that mean, exactly? (I think its a dispatch pointer, i.e., a recordset)

----- Darren Green wrote: -----

In article <95FDA809-8B1D-4061-9D3A-FCE004F240B1 (AT) microsoft (DOT) com>,
Casualinfoguy <anonymous (AT) discussions (DOT) microsoft.com> writes
In theory you could use the step execute method but this is not
recommended. You can execute SQL, not as a task but as a lookup, but
this can be any SQL you want and doesn't have to return anything.

There are alternatives for driving loops of a resultset, e.g.

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

Workflow
(http://www.sqldts.com/default.aspx?103)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

In article <DFBB8297-9DB9-4F99-9BA2-F8AAE23054D9 (AT) microsoft (DOT) com>,
Casualinfoguy <anonymous (AT) discussions (DOT) microsoft.com> writes

Darren, do you have a telephone number that I could speak to you
on, momentarily?

Please keep it in the newsgroup. It helps everyone this way.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

In article <67C50A81-582E-4F7C-9EFA-A602242720C9 (AT) microsoft (DOT) com>,
Casualinfoguy <anonymous (AT) discussions (DOT) microsoft.com> writes
and when you execute the package it will change the type for you. Global
variables are variants, so there are no type conversion issues to worry
about here. I almost always use strings, and if they get changed on
execution then so be it.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Darren, that seems to work fine. Thank you much.