ActiveX to execute Exec SQL task -- sql server dts

Ben
8/4/2005 12:45:07 PM

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

[quoted text, click to view]

Peter A. Schott
8/4/2005 2:13:20 PM

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

[quoted text, click to view]

Allan Mitchell
8/4/2005 8:29:42 PM

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

[quoted text, click to view]

Allan Mitchell
8/4/2005 9:32:05 PM

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%20Server\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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : ActiveX to execute Exec SQL task