Is there a problem mapping variables to resultsets with a bigint as datatype?
I've tried using int64, and others, but all fail except for object datatype.
I cant use object datatype because i wont be able to use it as a derived column.
Any ideas here?
Is this a bug in the current SSIS (bigint casting to variable)?If i modified the table structure to int and the variable to int32, it works fine.
|||Is this on Windows 2000, by any chance?|||It's on Windows XP.
Thanks.
|||
Big integers are returned now as strings. So if you choose your variable as a string variable you should be able to get the result correctly. This will probably change. soon.
|||This no longer seems to be the case and only maps to "object." Why is this and when will it be fixed?sql
No comments:
Post a Comment