Re: DTS Packages and Parameters

#1

OK Let me see if I get your situation

You set some GV values in the parent and pass then through to the child.
The child uses the value (GV) in a query but the parameter value is nested.

If this is the case then say you wanted to use the GV in an ExecuteSQL task
in the child then I would use a piece of Active Script task to set the
statement of the task before the actual ExecuteSQL task.

i.e.

Global Variables and SQL statements in DTS
http://www.sqldts.com/default.aspx?6,102,205,7,1

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Grant" <jamanella (AT) hotmail (DOT) com> wrote

Quote:

Greetings

I've set up a DTS package that contains an ActiveX
script task that sets 2 datetime global variables. The
next steps are Execute Package tasks that receive these
global datetime variables as parameters.

All is well except a few of the packages being called
have the parameters in nested queries. The error thrown
is "Parameter Information cannot be derived from SQL
statements with sub-select queries. Set parameter
information before preparing command" I've seen plenty
of ADO KB articles in which a solution is presented but
nothing with respect to how this can be done inside the
query portion of a DTS package.

Does anyone know if this can be done or if an alternative
is present. I've worked with SQL for several years but
only lightly with DTS packages. My end goal is to call
several packages that all have date criteria but only
want to change the date in one location instead of in
EVERY package.

Any insight would be greatly appreciated.

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: DTS Packages and Parameters

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: DTS Packages and Parameters - 07-11-2003 , 01:39 AM