Hi all

I have a very simple task to pass value which I retreive from execution task
against MS SQL Server and using it as an input parameter to another sql task
execution which happens to be an execution of procedure on Sybase.
How do I do that?

Look at the way we do things using parameters and/or global variables

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)

Introduction To Global Variables
(http://www.sqldts.com/default.aspx?280)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Gene." <Gene (AT) discussions (DOT) microsoft.com> wrote

Allan

I looked, did you? Do you know how exactly you can do that?
SQL Task executions do not accept 'parameters' and global variables could be
used with a very few tasks and sql task execution is not designed to use
global variables.

"Allan Mitchell" wrote: