This step-by-step tutorial has shown how to use the Visual
Studio 2005 IDE to create a MS SQL 2005 Server Integration Services Package. DTS
in SQL 2000 has its own design editor and it is not integrated with the Visual
Studio 2003. Packages created using the Import/Export Wizard can now be
modified in the VS 2005 IDE whereas this was not possible in DTS. Again, the
RAD capability is enhanced with more controls. However, more controls also
imply an increase in the steepness of learning. For copying and loading data
the Native OLE DB providers are recommended. As a comparison, the DTS example
shown earlier used an ODBC connection to Oracle which adds its own overhead. The
package created showed a simplified scheme where an Execute SQL statement was
first executed followed by an execution of the package. As this is intended to
be a basic tutorial, the focus was always maintained to describe the interface
in as much detail as possible. The readers may benefit by reading several of
my DTS related articles, the links to which can be found at my web site under tutorials. I
assumed that the reader knows how to create a new database in SQL 2005 Server
but, in case he/she does not they can look up this link.
I strongly urge the readers who may want to expand their DTS designer
experience to review those articles.