MS SQL Server DTS - DTS parameter with Integer data type

Author

DTS parameter with Integer data type

eam

2005-07-29, 3:24 am

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

Darren Green

2005-07-29, 3:24 am

In message <1122611301.954761.30360@g47g2000cwa.googlegroups.com>, eam
<eam52@shaw.ca> writes
>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
>

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

Sponsored Links