Using Business Intelligence Development Studio
One of the features of SSIS Import and Export Wizard is that the packages can be saved for later use and can be extended with BIDS. You have read about BIDS in Chapter 1 and have also created a blank Integration Services project.
In the following Hands-On exercise, you will open this blank project and then add the packages you just created using SSIS Import and Export Wizard. Don’t worry if you don’t understand exactly how Integration Services works; the purpose of the following exercise is to give you a preview, a feel, of how an Integration Services package looks. All the features shown are covered in detail in Chapter 3.
Hands-On: Exploring an SQL Server Import and Export Wizard Package Using ...
Get Hands-On Microsoft 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.
