Hands-On Microsoft SQL Server 2008 Integration Services part 64. Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource. . | 608 Hands-On Microsoft SQL Server 2008 Integration Services Figure 14-8 Connection Properties for the Campaign database 9. You can also execute your package in this Designer in the usual way by clicking Execute. Save your package and close the Designer. 10. Using Windows Explorer browse to the C SSIS RawFiles folder and delete the Importing package. 11. Now go back to SQL Server Management Studio and right-click the Importing Contacts and choose Export from the context menu. 12. Specify C SSIS RawFiles as the path to export Importing Contacts package. 13. Choose Start Run type cmd and click OK. At the command prompt type the following C dtsrun F C SSIS RawFiles lmporting You will see that the package executes successfully and 49 rows are added to the Contacts table as shown in Figure 14-9. Integration Services lets you run DTS 2000 packages as-is using the utility. For those who haven t used Data Transformation Services of SQL Server 2000 and are facing migration challenges now is the commandline utility used to run DTS 2000 packages. The jobs created in the SQL Server Agent to run DTS 2000 packages also use DTSRun to execute the jobs. This also means that all the jobs that were created in the SQL Server Agent will keep on Chapter 14 Migrating to Integration Services 2008 609 Figure 14-9 Running a DTS 2000 package running as is. If you who have extensively used and note that Integration Services provides equivalent rather better utilities called dtexec and dtexecui. The dtexecui utility can be used to create commands for use with dtexec. Refer back to Chapter 6 where these utilities are covered in detail. Review In this exercise you used SQL Server Management Studio to enumerate the packages stored in the sysdtspackages table of the MSDB database. You also used the import and export facility provided by SQL Server Management Studio and explored other available options. The important thing you .
