Showing posts with label bids. Show all posts
Showing posts with label bids. Show all posts

Wednesday, March 7, 2012

Integration with Team Foundation Server

Hi Everyone.
Does Business Intelligence Development Studio (BIDS) integrate with the Team Foundation Server? I've read that BIDS is based on VS.NET, but it's a different client than standard VS.NET.
Can we setup a Team Foundation Project and integrate the work item lists, check in policies, etc, with BIDS?
Thanks,
RobBIDS is actually just a copy of the VS IDE so in theory it should work. But it does not come with the Team Foundation Project, only the BI projects. YOu can upgrade BIDS to a full copy of VS by just installing over the top, this will keep the BI projects. Or you can just install the BI projects into a VS installation.

Management Studio uses VS technology and so will not automatically work with TS.|||I have this working without problem, though my understanding was that the latest patch set for TFS included support for the full set of database projects in VSTS.

Integration with Team Foundation Server

Hi Everyone.
Does Business Intelligence Development Studio (BIDS) integrate with the Team Foundation Server? I've read that BIDS is based on VS.NET, but it's a different client than standard VS.NET.
Can we setup a Team Foundation Project and integrate the work item lists, check in policies, etc, with BIDS?
Thanks,
RobBIDS is actually just a copy of the VS IDE so in theory it should work. But it does not come with the Team Foundation Project, only the BI projects. YOu can upgrade BIDS to a full copy of VS by just installing over the top, this will keep the BI projects. Or you can just install the BI projects into a VS installation.

Management Studio uses VS technology and so will not automatically work with TS.|||I have this working without problem, though my understanding was that the latest patch set for TFS included support for the full set of database projects in VSTS.

Friday, February 24, 2012

Integration Services and VS 2005 Pro

My client machine has VS Studio 2005 Professional installed. My server has SQL Server 2005 Enterprise with BIDS installed. I would prefer to do my task development on my client instead of the server. How do I get the Integration Services projects on my installation of VS 2005? I went so far as installing SQL Express and BIDS on my local machine, but the only Business Development projects I get are Report Server. Any assistance would be greatly appreciated.

Thanks,

Lee

You need to get SQL Server 2005 Developer Edition on your local machine. SSIS isn't included in Express edition.

|||

Why do I even need a version of SQL Server locally? Can't I utilize the installation of SQL Server Enterprise on my server?

|||You don't have to have the database installed, just the tools.