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.
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 SSISIf 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 |
|
|
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:Int32int64ObjectSbytesinglestringuint32uint64booleanbytechardatetime |
|
|
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. |
|
|
|
|
|