sql server dts: how can i set the Variables to a value in a asp script?
i have created a dts packedge which include a goble Variable.
the sql task just like 'select * from table where id>?'
and the goble Variable is named myid.
how can i set the Variable 'myid' to a value in a asp script?
can anyone help?
thanks!

Where does the ExecuteSQL task come into this? Is it because you want
to set a value of a variable just like that?

You are first going to get a reference using the DTS object model to the
package object. You will then use the GlobalVariablesCollection to
retrieve your variable and assign it a value.

Things to look at

http://support.microsoft.com/?kbid=252987

http://www.sqldts.com/207.aspx

http://www.sqldts.com/265.aspx (.Net I know but it gives you an idea
where to find stuff)



--


Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com




[quoted text, click to view]