Skip to content

EEG SSIS Getting Started

Access the Dev Environment

For details, see 1pw. In a nutshell, we need to connect to Citrix, and from there via RDP to the database server GRPTVS01.

Access the code base

The code base is here: eeg/code/ssis at main · pwrp/eeg (github.com)

We are using the git client included in VS2019.

Solution

The SSIS packages are maintained in VS2019. It is installed on GRPTVS01, and currently logged in with Christoph's Microsoft Developer account.

The right solution is: OdooTOSQL

C:\Users\arcade\source\repos\pwrp\eeg\code\ssis\ETL\OdooTOSQL_LIVE\OdooTOSQL.sln

Deploy STG2DWH

  1. in VS, right-click project

  2. select deploy

  3. follow wizard
    see here https://docs.microsoft.com/en-us/sql/integration-services/packages/deploy-integration-services-ssis-projects-and-packages?view=sql-server-ver16

eeg-ssis-getting-started-deploy-1.png

eeg-ssis-getting-started-sql.png
eeg-ssis-getting-started-deploy-connect-1.png

Run a package

  1. in SSMS, go to "Integration Services Catalogs"

  2. navigate to the package, e.g. SSISDB > OdooToSQL > Projects > OdooToPROD > 00.ETL.dtsx. Right click an run. Accept to open the overview report.

  3. refresh to see the results

  4. verify the results

eeg-ssis-getting-started-target.png

eeg-ssis-getting-started-run-1.png

Verify the schedules

see here: https://www.mssqltips.com/sqlservertutorial/9069/deploy-and-schedule-an-sql-server-integration-services-ssis-package-step-by-step/

  1. in SSMS, go to SQL Server Agent

  2. open Jobs

  3. check the properties of a job

  4. Select the step and click Edit

  5. at the bottom, you'll see the package