Results 1 to 2 of 2

Thread: bigint usage in SSIS

  1. #1
    Join Date
    Nov 2002
    Posts
    231

    bigint usage in SSIS

    Hi,
    I'm trying to get a bigint data type value form source table and assing into SSIS varaible.
    If i'm createing variable with int64/int32 in SSIS getting the below eror.
    [Execute SQL Task] Error: An error occurred while assigning a value to variable "GvMaxEndID":
    "The type of the value being assigned to variable "User::GvGvMaxEndID" 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 bigint type usage in SSIS realy appreciated.?

  2. #2
    Join Date
    Nov 2002
    Posts
    231
    I found answere my slef. here is resolution.
    Assign Vailable as a String and use input parameter as Long.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •