Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Mapping bigint to SSIS variables Expand / Collapse
Author
Message
Posted Tuesday, December 9, 2008 11:06 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, June 30, 2014 1:23 PM
Points: 336, Visits: 866
Mapping bigint variables ---

I want to store the result set from a SQL query in a variable in SSIS package..
the value tht i am getting is of type bigint...

What should be my variable type to make it work as int32 and int 64 is not working...

Error
[Execute SQL Task] Error: An error occurred while assigning a value to variable "MaxKey_": "The type of the value being assigned to variable "User::MaxKey__Work" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object. ".

Thanks 4 ur help



---------------------------------------------------

Thanks
Post #616357
Posted Wednesday, December 10, 2008 3:41 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 5:27 PM
Points: 1,117, Visits: 2,219
Check this post.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Post #617458
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse