Page 1 of 1

SK generator Bigint to Target Sqlserver05 Bigint

Posted: Tue Oct 09, 2007 10:37 am
by ds_is_fun
Im creating a surrogate key column whose datatype is Bigint.
I then move this over to a target column whose type is also BigInt.
In the warning message is see-
Process_Run_Id: When checking operator: When binding output interface field "Process_Run_ID" to field "Process_Run_ID": Implicit conversion from source type "uint64" to result type "int32": Possible range limitation.
How do I convert?
Thanks

Posted: Tue Oct 09, 2007 10:48 am
by DeepakCorning
got this post but not sure if u have the same issue --

http://dsxchange.com/viewtopic.php?t=94 ... 570cf9fa31