Is it possible to have exec sql's that are not included in the
workflow of the package that can be called from an activex script in
the workflow when needed?

I'm having trouble referencing the exec sql object from inside the
activex and using the execute method. can someone post a code snippet
that illustrates the referencing of an exec sql object and the use of
the execute method please.

Thanks,
Madhusudhan

Never done it. Never needed to. Others have looked and i do not know that
anybody really got it to work. I am not sure that MS think it a good thing
either.

You may want to use ADO in the Acive Script task or you may want to
selectively turn the task on and off from your code and use constraints.

Multiple Paths in Workflow
(http://www.sqldts.com/default.aspx?218)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Madhusudhan" <gurumum (AT) email (DOT) uc.edu> wrote

Thanks Allan,
what do you mean by turning the exec sql task on and off?

i am able to stall the exec sql which is not in the workflow by using
flags in the workflow acivex script of the exec sql object.

Out of curiosity, "execute" is listed as a method applicable to the exec
sql object.
I presume it is for use within activex scripts.

"You may want to use ADO in the Acive Script task or you may want to
selectively turn the task on and off from your code and use constraints"

can you show how this is done or point me to some sample code?

Sorry if my questions are a bit asinine. just starting off with dts.

Thanks for your help so far.

Madhusudhan

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

By turning it on and off I mean making a decision in a task up from the
ExecuteSQL task as to whether it should run.

Look at this

Multiple Paths in Workflow
(http://www.sqldts.com/default.aspx?218)

You are right the method is there but again I have never used it and the
people on this group that have, I cannot remember one that got this to work
properly.

ADO Code.

http://www.15seconds.com/issue/010718.htm

Your questions are not asinine. We all have to learn sometime and we are
gentle on this Group.


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Madhusudhan Gurumurthy" <madhu.gurumurthy (AT) ececs (DOT) uc.edu> wrote