Is there a way I can pass on variables from a stored procedure to a
DTS-package. I prefer to run this DTS-package as a job because of policy's by
the customer.

Thanks in advance.

Something like this?

Global Variables and Stored Procedure Parameters
(http://www.sqldts.com/default.aspx?234)

--



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


"Chris Plenter" <ChrisPlenter (AT) discussions (DOT) microsoft.com> wrote

No, this is passing variables into stored procedures. I want to start a job
using the command 'MSDB.dbo.sp_start_job @jobname'. This job will run
a DTS-package. I want to set a global variable in this DTS passed trough by
T-SQL.
Best option I have now I think is just setting a value in the database by
T-SQL and read it out with DTS when configuring global variables.

But if you have any other suggestions I would appreciate if you let me know.

Best regards,

Chris

"Allan Mitchell" wrote:

Ok then your original post was interpreted as you want to use a stored proc
in your package and utilise Global Variables

You can use the sp_OA suite of commands
You can also use xp_cmdshell

Having your package read an external source using the Dynamic Properties
task is also a very good option.

--



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


"Chris Plenter" <ChrisPlenter (AT) discussions (DOT) microsoft.com> wrote

Chris Plenter wrote:
look here:

"you can capture stored procedure return values and output parameters into
global variables using the Output Parameter functionality of the Execute SQL
Task in SQL Server 2000."

http://www.sqldts.com/default.aspx?234