From the course: SQL Server 2008 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using Business Intelligence Development Studio (BIDS)

Using Business Intelligence Development Studio (BIDS) - SQL Server Tutorial

From the course: SQL Server 2008 Essential Training

Start my 1-month free trial

Using Business Intelligence Development Studio (BIDS)

“

To work with SQL Server Integration Services we're going to open a new program. Well, for some of you it might not be that new. I'm opening up my SQL Server 2008 R2 applications. I'm looking for SQL Server Business Intelligence Development Studio, sometimes known as BIDS. But when I open this up, it's really not a completely new application. As I can see here it's actually Visual Studio. In fact Business Intelligence Development Studio is just a cut-down version of Visual Studio. If you have the full version of Visual Studio, every time you go to File > New > Project you might have dozens of choices to choose from, but here we only have a handful. We have a couple of Analysis Services Projects, we have a couple of specialized Reporting Services Projects and then the Integration Services one, and that's what I need to do. So I've gone into my File > New > Project and I'm going to create a sample here. I'll call it SSISTest and just accept the default location. So this is creating a…

Contents