Datasheet

most appropriate. Microsoft made a huge investment in usability and making it so that there is no longer
a need for scripting.
Most of this book will assume that you know nothing about the past releases of SQL Server DTS and will
start with a fresh look at SQL Server 2005 SSIS. After all, when you dive into the new features, you’ll
realize how little knowing anything about the old release actually helps you when learning this one. The
learning curve can be considered steep at first, but once you figure out the basics, you’ll be creating what
would have been complex packages in SQL Server 2000 in minutes.
You can start differentiating the new SSIS by looking at the toolbox that you now have at your fingertips
as an SSIS developer. The names of the tools and how you use them have changed dramatically, but the
tools all existed in a different form in SQL Server 2000. This section introduces you briefly to each of
the tools, but you will explore them more deeply beginning in the next chapter.
Import and Export Wizard
If you need to move data quickly from almost any OLE DB–compliant data source to a destination, you
can use the SSIS Import and Export Wizard (shown in Figure 1-1). The wizard is a quick way to move
the data and perform very light transformations of data. It has not changed substantially from SQL
Server 2000. Like SQL Server 2000, it still gives you the option of checking all the tables you’d like to
transfer. You also get the option now of encapsulating the entire transfer of data into a single transaction.
Figure 1-1
2
Chapter 1
04 584359 ch01.qxd 12/16/05 10:20 PM Page 2