Professional SQL Server™ 2005 Integration Services
by Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson, Kathi Kellenberger, Andy Leonard, Erik Veerman, Jason Gerard, Haidong Ji, Mike Murphy
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.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access