Friday, March 30, 2012

Mapping Variables to Resultsets

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