You can verify that the mail
has been sent.
Summary
This chapter described in detail the steps involved in using a File System Task to
copy a file from one directory to another directory. The steps need to send this
copied file by email was described, and in doing so the concept of Precedence
Constraint and its usage was described.
Package to Copy a Table
from Oracle XE
Modern business enterprises have to contend with resources from disparate vendors
of databases for many different reasons, that includes historical: new developments
in technology; cost concerns; acquisition of resources (M & R), etc. For example,
although a large hospital might have its main database using Oracle or SQL Server
2005, the various departments and cost centers may use other products. In these
cases, it is important to have the capability of easily transferring objects from one
vendor type product to the other. Every database vendor provides a built-in toolset
to address the migration of database objects, or whole databases to another vendor
type database.
Although this tutorial describes the details of copying a Table from Oracle 10G XE to
an SQL Server 2005 database using a SSIS task, you should review an earlier article
(http://www.devshed.com/showblog/28087/StepByStep-Guide-to-Importing-
Data-from-Oracle-XE-to-SQL-2005/), which uses the IMPORT / EXPORT utility
to import data from Oracle 10G XE to SQL Server 2005.
In this exercise, we will transfer a Table from the hr database on the local Oracle
10G XE server to the MyNorthwind database on the local SQL Server 2005 using a
Data Flow Task.
Pages:
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147