Problem with assigning BIGINT value to a variable(int64)

• Hari.Sharma

  SSCertifiable

  Points: 6904

  More actions

  July 25, 2008 at 3:32 am

  #125032

  Hi,

  I want to set a variable (int64) with BigInt datatype using SQL Execute Task.

  But following error occurs while I run the package:

  [Execute SQL Task] Error: An error occurred while assigning a value to variable "MaxID":

  "The type of the value being assigned to variable "User::MaxID" differs from the current variable type.

  Variables may not change type during execution. Variable types are strict, except for variables of type Object.

  Any suggestion for assigning bigint valur to a variable of Int64 in SSIS realy appreciated.?

  Thanks in advance

  Cheers,
  Hari
  Tips & Tricks for SQL BI Developers