August 24, 2010 at 10:47 am
We are using SQL Server 2005 with SSIS BIDS with included Visual Studio 2005. However, our development is currently all being done with Visual Studio 2008 TFS with all our code and server packages checked into theTeam Foundation Server. Our lead analyst is manually checking in SSIS packages created with VS 2005.
Our VS 2008 TFS environment was created without the BIDS template. I know it is possibe to add BIDS to VS 2008, I have seen it done before. However, I do not how it was done. Can you please explain how to add BIDS (for SQL Server 2005) to our VS 2008 TFS system so we can check out and in packages with TFS?
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler
March 3, 2011 at 11:37 am
Did you ever get an answer? I am looking how to do this myself.
March 4, 2011 at 1:54 am
It would surprise me if you can add BIDS 2005 into Visual Studio 2008.
Packages developed in 2008 are not compatible with 2005.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 4, 2011 at 8:55 am
Exactly what Koen said: packages and solutions are incompatible between VS versions. Once you upgrade a package or solution by bringing it into VS2008, you're unable to edit it in VS2005. Make a backup in a different location of your original 2005 work in case you need to reference or execute a 2005 package post-upgrade of your environment. Also, keep in mind that you'll likely need to tweak script components to get them running in 2008 (variable scopes and initializations, especially - just depends on what the scripts are).
Key point: it's a one-way street ... make a backup.
March 4, 2011 at 10:00 am
OK....How about getting BIDS 2008 into VS 2008??
March 4, 2011 at 10:08 am
All you should need to do is install SQL Server 2008 Standard (or higher, or use the Dev edition). BIDS is essentially a shelled-VS environment that is part of the SS installation. You don't necessarily have to install a full-blown SS instance, but can just install the client tools to get SSMS, BIDS, etc.. I don't think you'd get it in a free/Express edition, but I may be wrong.
March 4, 2011 at 10:24 am
The end result, that I desire, is to open my Visual Studio and have all the templates available, C#, VB, SSIS, SSAS, RS, etc.., etc... and not have to open BIDS to get the SSIS templates or have to open VS to start a VB project.
March 4, 2011 at 1:13 pm
I'm not sure in a SS2008 / VS2008 environment ... think I saw some posts about a CTP6 that had something to do with that, but I'm not positive (would have to set up a test install to see what the net result was). From what I've seen in a SS2008 / VS2010 setup, the BIDS templates aren't loaded in VS (i.e., they live/run side-by-side).
March 4, 2011 at 2:32 pm
As far as I know:
if you don't have Visual Studio, BIDS 2008 is installed. As mentioned before, this is just a shell of visual studio.
If you have Visual Studio 2008 installed, the business intelligence template is installed inside Visual Studio. So you can create any type of project (SSIS, SSAS, SSRS, C#, VB, ...) with one program.
Now, pay attention:
if you install Visual Studio 2010, it will still work for the usual stuff (aka VB, C# et cetera), but BIDS won't work in Visual Studio 2010 (yet). Visual Studio 2010 compatability with BIDS is foreseen within Denali (the next version of SQL Server). So, if you have BI projects lying around on your computer and you install VS 2010, they won't work anymore. Amazing isn't it?
So you need to install VS 2010 allongside VS 2008 (or BIDS 2008) to be able to edit and create BI projects.
The funny thing is, if you have both versions installed and you double click on a SSIS project, it is 2010 that opens. Yeah, the one that doesn't work... :crazy:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 4, 2011 at 2:38 pm
The funny thing is, if you have both versions installed and you double click on a SSIS project, it is 2010 that opens. Yeah, the one that doesn't work... :crazy:
"Future functionality." lol ...
I did see in a few places that the next SS was possibly having that integration, but it didn't look like it was confirmed, yet.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply