If you want to pass parameters to a strored proc that you execute in DTS
have a look at this article and let us know if it does what you want
Global Variables and Stored Procedure Parameters
(http://www.sqldts.com/Default.aspx?234)
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"anonymus" <anonymous (AT) discussions (DOT) microsoft.com> wrote
Quote:
I have a script as follows:
exec test1 @id
In Test1 stored procedure
Depending on the parameter I have to execute a stored procedure and send
the out put to an xls file. It is easy to send the output of a stored
|
procedute to a file using DTS but only problem is there is no way of sending
the parameters to it. Any idea?
Re: passing parameters to dts -
03-05-2004
, 12:37 PM
Linear Mode
