Execute the SSIS Package

Before you begin

Create a configuration table.

About this task

This topic describes how to execute the Integration Services (SSIS) package.

Procedure

  1. Access SQL Server Management Studio (SSMS).
  2. Right-click the package that you have imported.
  3. Select Execute, verify the connection manager properties, and then select OK.
    A message appears, asking you if you want to access the overview report.
  4. Select Yes.
    The package is executed, and the overview report appears. The status is displayed as Running, and then changes to Succeeded. If, however, the execution fails, select View Messages to view the logs.
  5. Verify the data imported into tables using queries, and verify the number of records from flat files and tables.
  6. Verify the files imported with record count by querying the [dbo].FileLoadInformation table.

Issue: Executing the SSIS Package Fails

Diagnostics: Identify the package/task that contains an error. To do so:
  • In the overview report, select View Messages to access the logs.
  • Query the [dbo].Logs table.
  • Query the sysssislog table, which is created in System Tables.
For more information on the logs, access the following file: C:\SSIS_Project\HistoryTableDataImport_V1\Log\Output.log

What to do next

Create primary keys for the history tables.