Creating Packages with the SQL Server Import And Export Wizard
Creating an Integration Services package can be one of the most complex tasks you perform as a database administrator. Fortunately, the SQL Server Import And Export Wizard is designed to help you build Integration Services packages with minimal difficulty, but it is still an involved process. To help reduce complexity, we can divide the creation process into stages and then examine each stage individually. The stages you use to create Integration Services packages are as follows:
Stage 1: Source and Destination Configuration
Stage 2: Copy or Query
Stage 3: Formatting and Transformation
Stage 4: Save and Execute
To begin using Integration Services, start the SQL Server Import And Export ...
Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant 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.