Import the SSIS Package

Before you begin

Export history tables.

About this task

This topic describes how to import the Integration Services (SSIS) package into SSMS.

Procedure

  1. Download the HistoryTablesDataImport_V1.zip file from the support portal.
  2. Create a folder named SSIS_Project in the C drive.
  3. Extract the contents of the HistoryTablesDataImport_V1.zip file into the folder that you have created.
  4. Modify the configuration:
    1. In the HistoryTablesDataImport_V1 folder that you have extracted, access the Conf folder.
    2. Access the PackageConfig_WAuth.dtsConfig file, and then provide Windows authentication details as follows: Data Source=<SQL server name>;Initial Catalog=<database name>;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;
    3. Access the PackageConfig_SQLAuth.dtsConfig file, and then provide the SQL user authentication details as follows: Data Source=<SQL server name>;Initial Catalog=<database name>;User ID=<username>;password=<password>;Provider=SQLNCLI11.1;Persist Security Info=True;Auto Translate=False
    4. Access the PackageConfig_FlatFileFolder.dtsConfig file, and then provide the folder path to the source flat files.
  5. Access SQL Server Management Studio (SSMS) (in which the integration service is installed with the SQL server).
  6. Log in to the integration service using Windows authentication.
    Windows authentication is mandatory to deploy and execute SSIS packages.
  7. In the Object Explorer window, right-click Integration Service Catalog, and create a catalog (if you have not created one).
  8. Right-click the catalog that you have created, and then select Create Folder.
    After a few minutes, the folder is created, along with two subfolders, Projects and Environments.
  9. Right-click Projects, and then select Import Packages.
    The Integration Services Project Conversion Wizard window appears.
  10. Select Locate Packages.
  11. In the Source box, select File System.
  12. Provide the path of the HistoryTablesDataImport_V1 folder, and then select Next.
  13. Select all the packages in the list, enter the password, and then select Apply to selection.
  14. Select Next.
    Downloading the packages begins.
  15. Under Update Execute Package Task, in the Tasks section, clear the Parent Package check box, and then select Next.
  16. Under Select Configuration, clear the Package check box, and then select Next.
  17. Accept the default values for Create Parameters and Configure Parameters, and then select Convert.
    The packages are converted, and the results appear.
  18. Verify that the results pass for all the packages, and then select Close.
    The Integration Service Project Deployment Wizard window appears, asking you to enter the project password.
  19. Enter the password.
  20. In the Deployment Target box, select SSIS in SQL Server, and then select Next.
  21. Enter the destination SQL server name, select Windows Authentication, and then select Connect.
  22. Select Next.
  23. Verify the details, and select Deploy.
    The packages are deployed, and the results appear.
  24. Verify that the deployment is successful, and then select Close.
  25. Verify that all the packages inside the HistoryTablesDataImport_V1 folder are available in the Projects folder in the project that you have created in Integration Services Catalogs.

What to do next

Create a configuration table.