Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Variable data type in SSIS

Author  Topic 

jung1975
Aged Yak Warrior

503 Posts

Posted - 2007-08-31 : 17:33:43
how to pass the numeric(12,0) data type to a variable in SSIS? what kind of variable data type should I choose?
I am trying to assign object_key column ( numeric(12,0)) to a variable in SSIS

If i select int32 , it keep giving me an error:
Error: 0xC001F009 at Row by Row process: The type of the value being assigned to variable "User::Object_Key" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.


mwjdavidson
Aged Yak Warrior

735 Posts

Posted - 2007-09-03 : 04:08:02
DT_NUMERIC?

Mark
Go to Top of Page

jung1975
Aged Yak Warrior

503 Posts

Posted - 2007-09-04 : 16:41:10
there is no numeric data type in variable..

if you click the drop down box in variable data type, you can only see the below data type:

Int32
int64
Object
Sbyte
single
string
uint32
uint64
boolean
byte
char
datetime


Go to Top of Page

CoffeeAddict
Yak Posting Veteran

94 Posts

Posted - 2012-09-17 : 11:53:16
Yea and none of those work jung with an incoming DT_NUMERIC to variable. Double doesn't work as the variable type so what the hell DOES work for SSIS? I'm equally as frustrated about this pile of junk.
Go to Top of Page
   

- Advertisement -