Re: Global Int Variables

#1

Correct. It will try to convert it to a BSTR (string) as it thinks the
value you enetered is "". I would default it to 0. I would also have it as
type INTEGER. There was a thread a while ago with a person from MS re
unexpected domains of the datatypes.

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Narendra" <nnarendra (AT) yahoo (DOT) com> wrote

Quote:

Hi Guys,

The problem is pretty straight forward and it is not a
real issue, but I was just wondering if this is how Non
Char DTS Global Variables work.

I went into package properties/Global Variables tab and
tried to create a global variable with the following
properties. Name = 'intT1', Type = int and I left Value
field as it is assuming my variable will have a NULL value
and clicked OK. The message I got is as follows, I guess
DTS is trying to convert the Text value '' to an integer
and as a result I might be getting this message.

MESSAGE - Could not convert variable T1 from type BSTR to
type Unsigned Int.

Does it mean I have to create a global variable other than
Non Char with a predefined value? It doesn't hurt my work,
but just thought of finding out from here.

Thanks,

Narendra

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

Re: Global Int Variables

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

Re: Global Int Variables - 11-06-2003 , 04:13 PM