This link http://www.sqldts.com/?234 references a method of tricking DTS
into accepting both an input and output parameter using this code:

SELECT id AS OutputTest FROM sysobjects where id = ?

That line of code only works for 1 input and 1 output parameter. Anyone know
a way to increase the number of input and output parameters that can be
passed in and out? Thanks very much.

In article <2lq6dtFfgnqcU1 (AT) uni-berlin (DOT) de>, Ghetty wrote:
I don't know that we would call it a trick but have you should be able to
carry on the method to include numerous params

SELECT ...... FROM TABLE WHERE col1 = ? AND col2 = ?




Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
www.konesans.com - for all your consultancy needs

Allan,

Maybe I'm being dense, but I don't understand...
I'm not referring to passing multiple input parameters and no output
parameters or vice versa. I'm referring to passing in multiple input
parameters AND passing out multiple output parameters within the same
Execute SQL Task. Thanks!

In article <2lqnnpFdnaddU1 (AT) uni-berlin (DOT) de>, Ghetty wrote:
Have you tried

So say I want to do this

SELECT au_id, au_lname from Authors where au_fname = ? And state = ?

For my Input paramaters I get prompted for 2
For my output paramaters (Row Value) I also see 2

Is this not what you mean?


--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
www.konesans.com - for all your consultancy needs

Yes. Why is your example not working for me? As described in the
aforementioned
article, an error pops up if I try to use anything but the work around code
of

SELECT id AS OutputTest FROM sysobjects where id = ?

I'm using SQL Server 2000...
How does one go about checking for updates to SQL Server? Perhaps that's the
issue...

Thanks!

In article <2lri1iFfnrhkU1 (AT) uni-berlin (DOT) de>, Ghetty wrote:
In Query Analyser you can do this

SELECT @@version

What does that tell you?

There is no auto-update feature for SQL Server but the SPs are available on
the MS Site.




Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
www.konesans.com - for all your consultancy needs