March 25, 2008 at 7:39 am
We're in the process of *finally* moving to SQL Server 2005, and are working on migrating our old DTS packages to Integration Services. One of my coworkers has already worked on getting them converted.
I just installed Visual Studio 2008, and uninstalled VS2005 as my programming projects all checked out as fine using the new IDE. However, this morning I went to look at some of the Integration Services packages, and realized that the "SQL Server Business Intelligence Development Studio" link pointed to VS2005, and is now broken.
Can you manage int. services packages in a mixed environment with both VS2008 and VS2005? Can you even manage int. services packages from SQL2005 with VS2008? If I edit a package in VS2008, will a user still be able to open it with VS2005 as well?
Thanks for any tips or info!
March 25, 2008 at 8:30 am
Run VS2005 and 2008 side-by-side - they do not interfere with each other. Use VS2005 for BI development (SSIS, SSAS, and SSRS) and use VS2008 for application development.
March 25, 2008 at 8:58 am
Yeah, I've determined that from some more searching. Bah! What a stupid, stupid move. I was able to reinstall the stripped down VS2005 from the SQL install disc, and it looks like that will work. It just annoys me that I have to have a completely separate installed tool to work with something when things should be backward compatible. What major changes were made between 2005 and 2008 that won't let 2008 work with SSIS 2005 packages? Why do I have to have another 3gig installation just to do SSIS? What if I have a mixed environment of SQL 2005 and 2008, I need to have VS2005 and VS2008 at the same time, too?
Sigh.....Microsoft - making this harder so they are easier.....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply