Re: Passing Values to Global Variables

#1

You can use the sp_OA** stored procs to execute a package in TSQL.
You can use xp_cmdshell and DTSRUN to execute a package in TSQL

Execute a package from T-SQL
(http://www.sqldts.com/Default.aspx?210)

Execute the Stored proc inside the package and assign the results inside.

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

--

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

"Brandon Campbell" <bkc5 (AT) cdc (DOT) gov> wrote

Quote:

Hello,

How does one pass a value from a store procedure to a
package that contains global variables. I know how to do
this as a batch file, but I would like to keep everything
on the server.

Second, I know there is a stored procedure that executes a
package, could you please tell me what that procedure is.

Thank you,

Brandon

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

Re: Passing Values to Global Variables

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

Re: Passing Values to Global Variables - 11-13-2003 , 08:06 AM