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.

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

Management Studio to remember servers?

If I "Connect" to different SQL Servers in Object Explorer, close and reopen SQL Management Studio, the list of Servers is Object Explorer is blank. Each time I need to re-connect to my list of SQL Severs.

Anyone know how to get Management Studio to remember list of connctions in Object Explorer?

Thanks,

Chris Skor

I don't belive this is possible, and would probably be a bit too much. Do you use Registered Servers? Register each server you use reguarly, then it is easy enough to just double click the server so that it connects and opens object explorer. Hopefully this will suffice?|||

In addition, you can configure SSMS to start up without prompting for a connection.

Tools -> Options -> "At Start up:" "Open an empty environment" is the setting you'll want.

This way you can jump into the environment really quick and then select the server to connect to using the Register Servers tool window. You can use folders in this window to group servers.