SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Variable data type in SSIS		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jung1975
Aged Yak Warrior

USA
503 Posts
Posted - 08/31/2007 :  17:33:43  Show Profile  Reply with Quote
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

United Kingdom
735 Posts
Posted - 09/03/2007 :  04:08:02  Show Profile  Reply with Quote
DT_NUMERIC?

Mark
Go to Top of Page

jung1975
Aged Yak Warrior

USA
503 Posts
Posted - 09/04/2007 :  16:41:10  Show Profile  Reply with Quote
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 - 09/17/2012 :  11:53:16  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000