-
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.?
-
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
-
Forum Rules
|
|