Thursday, July 10, 2008

Creating a New Integration Services Project

Creating a New Integration Services Project
The first step in creating a package in Microsoft SQL Server 2005 Integration Services (SSIS) is to create an Integration Services project. This project includes the templates for the objects — data sources, data source views, and packages — that you use in a data transformation solution.
The packages that you will create in this Integration Services tutorial interpret the values of locale-sensitive data. If your computer is not configured to use the regional option English (United States), you need to set additional properties in the package. The packages that you use in lessons 2 through 5 are copied from the package created in lesson 1, and you need not update locale-sensitive properties in the copied packages.
To create a new Integration Services project

On the Start menu, point to All Programs, point to Microsoft SQL Server 2005, and click SQL ServerBusiness Intelligence Development Studio.
On the File menu, point to New, and click Project to create a new Integration Services project.
In the New Project dialog box, select Integration Services Project in the Templates pane.
In the Name box, change the default name to SSIS Tutorial. Optionally, clear the Create directory for solution check box.
Accept the default location, or click Browse to browse to locate the folder you want to use.
In the Project Location dialog box, click the folder and click Open.
Click OK.
By default, an empty package, titled Package.dtsx, will be created and added to your project.
In the Solution Explorer toolbar, right-click Package.dtsx, click Rename, and rename the default package to Lesson 1.dtsx.
When prompted to rename the package object, click Yes.
To set locale sensitive properties

On the View menu, click Properties Window.
In the Properties window, set the LocaleID property to English (United States).
For more details http://technet.microsoft.com/en-us/library/ms170057.aspx

No comments: