tailieunhanh - Microsoft SQL Server 2005 Developer’s Guide- P41

Microsoft SQL Server 2005 Developer’s Guide- P41:SQL Server 2005 is a feature-rich release that provides a host of new tools and technologies for the database developer. This book is written to help database developers and DBAs become productive immediately with the new features and capabilities found in SQL Server 2005. | Chapter 10 SQL Server Integration Services 379 . NOTE --------- Don t be confused by the fact that the SSIS Designer is started from the Business Intelligence Development Studio. SSIS is not limited to just Analysis Services projects. The projects developed in the Business Intelligence Development Studio are fully capable of working with relational data. Open the BIDS and then select the File New Project option to open the New Project dialog. To create a new Integration Services project select Business Intelligence Projects from the Project Types list and then Integration Project from the list of templates as is shown in Figure 10-4. When the SSIS Designer first starts you re presented with a blank design surface like the one shown in Figure 10-5. Defining Tasks At this point to build an SSIS package you need to drag and drop tasks from the Control Flow toolbox onto the design surface that represent the actions that you want the package to perform. To construct the sample package you need to use an FTP task a SQL task and a Data Flow task. As you might imagine Figure 10-4 Opening a data transformation project 380 Microsoft SQL Server 2005 Developer s Guide Figure 10-5 The SSIS design surface the FTP task will transfer the file from the remote system. The SQL task will be used to create a new task to store the FTP data and the Data Flow task will transfer the data from the flat file to the SQL Server table and will also perform the lookups. You can see these tasks laid out on the SSIS design surface in Figure 10-6. You might notice in Figure 10-6 that the tasks are all marked with a red x. This indicates that the task has not yet been defined. At this point two things need to happen the precedence between the tasks needs to be defined and the tasks each need to be defined. To define the precedence between the tasks is easy. Defining Precedence The precedence essentially defines which task will be executed first which second and so on. To define precedence click each