DTS parameter with Integer data type

#1

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

#2

In message <1122611301.954761.30360 (AT) g47g2000cwa (DOT) googlegroups.com>, eam
<eam52 (AT) shaw (DOT) ca> writes

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS parameter with Integer data type

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS parameter with Integer data type - 07-28-2005 , 11:28 PM

Re: DTS parameter with Integer data type - 07-29-2005 , 01:19 AM