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

 http://www.sqlknowledgebank.blogspot.in/2013/01/understanding-bids.html

 SSIS Connection Manager
 http://www.sqlknowledgebank.blogspot.in/2013/02/ssis-connection-manager.html

 Introduction to Control Flow and Data Flow
 http://www.sqlknowledgebank.blogspot.in/2013/02/introduction-to-control-flow-and-data.html

SSSIS Control Flow Containers

http://www.sqlknowledgebank.blogspot.in/2013/02/ssis-control-flow-containers.html

References

http://msdn.microsoft.com/en-us/library/ms138028(v=sql.100).aspx