SSIS : variable types mapping problem 1

[p27br]

hello

i have a query in SQL Server 2005, that uses the DENSE_RANK() function which returns a bigint.
in my SSIS package, I have a recordset object which detects the field as [DT_I8]. I am trying to map a package variable to this field values in a loop but I keep getting a conversion error. The variable type is int64 which should map to bigint.

I am confused with all theses different names for the same types.
bigint = DT_I8 = int64 ?

My package runs if I use the object type, but Visual Studio will stop responding when it has looped through 30000 records, I think because the Object type makes it consume a lot of memory ?

 

[p27br]

this is the error message :

Error: The type of the value being assigned to variable "User::rank" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.

 

[p27br]

i think I have found the problem :
BigInt values are returned as Strings !
Apparently, this should have been corected by Microsoft, but was not. :/
if I cast my bigint to string, it works. but then i'll have to cast back to do divisions in my script task.