Chapter 2. The SSIS Tools
As with any Microsoft product, SQL Server ships with a myriad of wizards to make your life easier and reduce your time to market. In this chapter you'll learn about some of the wizards that are available to you. These wizards make transporting data and deploying your packages much easier and can save you hours of work in the long run. The focus will be on the Import and Export Wizard. This wizard allows you to create a package for importing or exporting data quickly. As a matter of fact, you may run this in your day-to-day work without even knowing that SSIS is the back-end for the wizard. The latter part of this chapter will explore other tools that are available to you, such as the Business Intelligence Development Studio.
Get Professional SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
