Export History Tables
Before you begin
Procedure
- Access SSMS.
-
Right-click Database, and then select .
The SQL Server Import and Export Wizard window appears, displaying the Choose a Data Source page
-
Select a data source:
-
Select a destination:
-
Select Copy data from one or more tables or views, and
then select Next.
The Select Source Tables and Views page appears.
-
Select the check box for the table that you want to export, and then select
Next.
Tip:
- You can view the first 100 rows of data in the data source by selecting Preview.
- You can edit the column mappings between the data source and destination by selecting Edit Mappings.
-
Select the Execute immediately check box, and then
select Next.
The Save SSIS Package page appears.
-
Select Next.
The Complete the Wizard page appears, displaying a summary of the options that you have selected.
-
Select Finish.
The history table is exported.