Where is BIDS??

[jsteph]

Hi all,
I'm fairly new to SSIS, had done some work with it at my old job. Now, I'm at a new place, and have a full MSDN subscription, have fully loaded VS-2010 and VS-2008, and did the full install of sql-server 2008 R2 including all client components. I have an existing project but I *cannot* open it in VS 2008 or VS 2010 because it says it "...the project type (.dtproj) is not supported by this application".

Now, I have googled this and I have to say my head is spinning. It seems like there is some kind of black-magic purgatory-land that BIDS exists in that is not found in the real world---something like "it works if you have sql-2005 and VS-2008, but not sql-2008 and vs-2008", or some other bizarre combination of versions and service packs and who-knows-what.

In my old place I never thought about it--there was an icon for it and it opened. Here, I've done the full, complete, extra-full, extra-complete, no-holds-barred, install-every-friggin-thing-in-the-world and I still can't open a BIDS project?

Please help, nobody here knows, it was on the machine of the guy I replaced and that has been cleaned. Now I'm sitting with a subscription to what I thought was access to every bit of software Microsoft has available...except BIDS.
--Jim

 

[xlbo]

AFAIK SSIS is 2008 only - ther is no upgrade for 2010 so you need to be using VS 2008



Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[xlbo]

so I would uninstall 2010 and make sure that it rolls bak properly to 2008 and try from there

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[jsteph]

xlbo,
Thanks very much...what I ended up doing was set up a virtual machine for my SSIS stuff--I've gone through so much hell in the past with trying to get SQL-server itself at the 'right' level, let alone Visual Studio. I didn't want to mess up the all the fresh re-installs I had to do when one of the "Express" or "Compact" or whatever myriad versions of sql-server got installed that trashed everything sql-server-wise. So the VM has been a reasonable solution...but it's still beyond my why MS would do this to developers.
--Jim