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