I have an activeX task that performs a loop and at the end of every loop i
want it to execute the exec sql task. I have tried:
Set objSQL =
DTSGlobalVariables.Parent.Tasks("DTSTask_DTSExecut eSQLTask_1").CustomTask
.....
objSQL.Execute

But i get an error "wrong number of arguments or invalide property"

How can this be done? The reason im doing it this way is that the query the
exec sql uses is dynamic to the current loop in the activeX control


thanks for any and all help!
Ben

Why not set the code for the ExecSQL using the Dynamic properties task and put
that right before the loop back to the beginning? That should work.

If the only change in the code is a parameter or piece of the where clause,
you may also be able to use Global Variables and the parameters function of
the Exec SQL task by placing a "?" every place you want to use a global
variable and then assigning those with the Parameters button.

-Pete

Ben <ben_1_ AT hotmail DOT com> wrote:

You can either wrap the statement into your Active Script task or you could
possibly adapt these

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

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)


--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Ben" <ben_1_ AT hotmail DOT com> wrote

thanks for both your answers. But i think you might have missed my question.
When i attempt to execute the exec sql task, it get the aboved mentioned
error. what are the parameters its wanting? I would perfer if my code didnt
change much, I would like the activeX scipt to invoke the other tasks without
worriing about "on success" options. I could easily do this with an ADO
connection, but i want to attempt it this way as well. It gives it a more
visually appealing look.

Thanks again
Ben

"Allan Mitchell" wrote:

I have never called the execute method on the task from inside another task
and do not know anyone else who does either.

You can though find the parameters you require in BOL

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

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Ben" <ben_1_ AT hotmail DOT com> wrote

Hello,

Sorry for troubling you after many years.Did you find the solution for this?

I need exactly same functionality now.
Thanks.

url:http://www.ureader.com/msg/11461238.aspx

On 25 Giu, 23:11, "padavala"<vpavanpadav... (AT) yahoo (DOT) com> wrote:
I see no reason for DTS letting you do this, but I cannot say for sure
it's not possible...
I guess this could bring you to break precedence constraints on tasks'
workflow.

That's the solution, IMHO
Bye,
M.