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?|||I submitted a Connect bug on this some time ago (https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=260967), and they've indicated that it was on the work list for Katmai (SQL Server 2008). I just tested against the November CTP and selecting a bigint column and storing it in an Int64 variable works.

No comments:

Post a Comment