Stay informed about any major changes. Click here to subscribe
Automate importing and exporting
Import/Export wizard can
be used to import and export data between heterogeneous OLE DB and ODBC
data sources. A package that the wizard
can save, specifies the source and target OLE DB data sources. The package
can be executed on an as-required basis or at scheduled times or intervals.
A single package can cover multiple tables. Packages are also not limited
to transferring data straight from one table to another, as the package
can specify a query as the source of the data. This allows packages to
transform data, such as running a query that returns aggregate summary
values instead of the raw data.