-
Download the HistoryTablesDataImport_V1.zip file from the
support portal.
-
Create a folder named SSIS_Project in the C drive.
-
Extract the contents of the HistoryTablesDataImport_V1.zip
file into the folder that you have created.
-
Modify the configuration:
-
In the HistoryTablesDataImport_V1 folder that you
have extracted, access the Conf folder.
-
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;
-
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
-
Access the PackageConfig_FlatFileFolder.dtsConfig
file, and then provide the folder path to the source flat files.
-
Access SQL Server Management Studio (SSMS) (in which the integration service is
installed with the SQL server).
-
Log in to the integration service using Windows authentication.
Windows authentication is mandatory to deploy and execute SSIS
packages.
-
In the Object Explorer window, right-click
Integration Service Catalog, and create a catalog (if
you have not created one).
-
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.
-
Right-click Projects, and then select Import
Packages.
The Integration Services Project Conversion Wizard
window appears.
-
Select Locate Packages.
-
In the Source box, select File
System.
-
Provide the path of the HistoryTablesDataImport_V1 folder,
and then select Next.
-
Select all the packages in the list, enter the password, and then select
Apply to selection.
-
Select Next.
Downloading the packages begins.
-
Under Update Execute Package Task, in the
Tasks section, clear the Parent
Package check box, and then select
Next.
-
Under Select Configuration, clear the
Package check box, and then select
Next.
-
Accept the default values for Create Parameters and
Configure Parameters, and then select
Convert.
The packages are converted, and the results appear.
-
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.
-
Enter the password.
-
In the Deployment Target box, select SSIS in
SQL Server, and then select Next.
-
Enter the destination SQL server name, select Windows Authentication, and then
select Connect.
-
Select Next.
-
Verify the details, and select Deploy.
The packages are deployed, and the results appear.
-
Verify that the deployment is successful, and then select
Close.
-
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.