Thanks for your replies and yes, I'm thinking it is the software doing this.

The example came from a query I wrote to look at all the PKs in the database...

A manager was looking to standardize development environments (prompted by the problem I was having, which started this post). One group needs VS 2010 for what they're doing. ...

Right, SQL Server 2008 R2, which runs VS 2008 with different options than "regular" VS 2008. So you can open SSIS projects, work on packages, etc., with VS 2008,...

Being able to create, edit, run, etc., SSIS packages in VS 2010.

Thank you both for your responses, much appreciated!

One question that arose in a meeting I just got out of was whether VS 2010 has support for SSIS. From what...

I did figure out how to convert the project and packages to VS 2008; go to the SQL Server 2008 R2 program group and click the Business Development Studio item....

Thanks, bteraberry! That is orders of magnitude simpler than what I came up with! I still have to tweak it a bit because the criteria changes twice within...

Thanks to both of your for your suggestions and time. It turned out to be MUCH more complicated than I realized.

For each row I have a key, a year...

By the way, sorry the data isn't formatted better...