Mapping bigint to SSIS variables

• sql_learner29

  SSCrazy Eights

  Points: 9107

  More actions

  December 9, 2008 at 11:06 am

  #127416

  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

  [font="Comic Sans MS"]
  ---------------------------------------------------

  Thanks [/font]

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  December 10, 2008 at 3:41 pm

  #910716

  Check this post.

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