I've writen an activeX script to get an xml doc from a url and then
assign one of the nodes to a global variable.

I then want to pass this variable to a SQL statement and thought I
could do this still using the DTS. So I set up a connection to my SQL
server and a sql command. The statement is:

Declare @partno nvarchar(255)

UPDATE productfeed
SET Stock = '99'
WHERE Manufacturer_Part_Number = @partno

Yet when I clcik the parameter button in the DTS for the SQL Command,
I get told, 'The SQL statemetn does not contain any parameters'

Can someone help me please as I need to pass the global var to this
statement as a parameter

Keith

change @partno to ?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
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


"M3ckon" <keith (AT) syance (DOT) com> wrote

thanks Alan,

sorry to be a pain, but how do I have several parameters??


can I just name them
?param1
?param2

Regards,

M3ckon

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

you just do

WHERE col1 = ? and col2 = ?

When you look at them in the DTS parameters section they are in order.


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
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


"m3ckon" <anonymous (AT) devdex (DOT) com> wrote