Wednesday, August 19, 2015

Important Facts SSIS

Important Facts SSIS


Introduction

Before going to deep with SSIS, we have to understand some important facts related to SSIS. I forgot it to mention in my previous articles related to SSIS. Here in this article I am trying to illustrate it. Here I am using Microsoft SQL server 2008 or 2008R2 version for SSIS solutions.

Relation with MS Visual Studio 2010

Microsoft Visual Studio 2010 does not support Business Intelligence Development Studio Integration Services, Report Services and Analysis Services projects for SQL Server 2008 or 2008R2 version. To work around this issue, you can install Visual Studio 2008 alongside Visual Studio 2010 on the same machine and then open the Business Intelligence Development Studio projects in Visual Studio 2008.

Creating Solutions In BIDS

When we are going to create a new solution, Business Intelligence Development Studio adds a Solution folder to Solution Explorer, and creates files that have the extensions are mentioned bellow.

File Extension
Description
.sln
The *.sln file contains information about the solution configuration and lists the projects in the solution.
.sou
The *.suo file contains information about your preferences for working with the solution.

Files in Integration Services Projects

When we add a new or an existing Integration Services project to a solution, Business Intelligence Development Studio (BIDS) creates project files that have the extensions are mentioned bellow

  • The *.dtproj file contains information about project configurations and items such as data sources and packages.

  • The *.dtproj.user file contains information about your preferences for working with the project.

  • The *.database file contains information that Business Intelligence Development Studio requires to open the Integration Services project.
Related Tropics

Understand the BIDS


SSSIS Control Flow Containers

References