In trying to convert decimal to integer within a transformation using below
code, I am getting error "Invalid Procedure call or argument: 'DTSSource'" at
execution. Can some point out how I can correct the error.

Dim newPRQtyPriceRecieved
newPRQtyPriceRecieved = DTSSource("cast(PRQtyPriceRecieved as integer )")
DTSDestination(" PRQtyPriceRecieved)") =newPRQtyPriceRecieved

Is that really the name of your column? cast(PRQtyPriceRecieved as integer )

Where are you doing this?

If you are coming from SQL Server have you tried simply converting in the
statement i.e.

CAST(<Source Column> as <DataType>)


You could even use STR()


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Liz" <Liz (AT) discussions (DOT) microsoft.com> wrote

should be
newPRQtyPriceRecieved = CINT(DTSSource(PRQtyPriceRecieved as integer ))

Ed

"Liz" wrote:

newPRQtyPriceRecieved = CINT(DTSSource("PRQtyPriceRecieved"))

Ed

"Ed" wrote:

Thank you all. Its all working with the following code:

DTSDestination("PRQtyPriceRecieved")=cint(DTSSourc e("PRQtyPriceRecieved"))

"Ed" wrote:

In message <2FF738F3-79EC-4590-AD73-6604D7F40079 (AT) microsoft (DOT) com>, Liz
<Liz (AT) discussions (DOT) microsoft.com> writes
Just be aware that a VB(Script) Integer as produced by CInt is only
equivalent to a smallint in SQL. So if using a int destination column,
use CLng for the conversion, giving a Long data type, albeit in a
variant.

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

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