Tuesday, May 22, 2007

BIGINT Confusion Explained

I've known for some time that to work with BIGINT values from SQL Server in SSIS, you needed to store them in String package variables - but I never knew why. Now, thanks to an excellent post from Matt Masson on the SSIS team, we know why:

http://blogs.msdn.com/mattm/archive/2007/04/18/why-can-t-i-store-my-bigint-result-in-an-int64-variable.aspx

Thanks, Matt!

No comments: