sql server dts: Is there a way to pass a users input through a DTS parameter that has a
integer data type without puting a constant in the value column. Ex A
string parameter accepts a ? for an input. However a @id
(Integer(small) will only take a number in the value rather than accept
a placeholder for user input.

Thanks in advance

EAM

In message <1122611301.954761.30360@g47g2000cwa.googlegroups.com>, eam
<eam52@shaw.ca> writes
[quoted text, click to view]

You should be able to use ? an integer place holder as well.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org