Video Tutorial

Content

• Video Tutorial
• Step-By-Step
• Properties
• Setting UI
• References

Video Tutorial

1. Firstly, You need to Download and Install PostgreSQL Database.
2. In order to connect to PostgreSQL Database from SSIS you will need Credentials. Ask your SysAdmin or responsible person to provide that to you.
3. Once you finished above steps, Open Visual Studio and Create New SSIS Package Project.
4. In Visual Studio, drag and drop the ZS PostgreSQL ExecuteSql Task in the design surface.
   
5. We need PostgreSQL Database connection.
6. Right click on Connection Manager and select New Connection.
   
7. Here, Select ZS-POSTGRESQL Connection Manager from the Connection Managers list and Click on Add Button.
   
8. On Connection Manager UI, Enter Host name and Enter your PostgreSQL Username and Password even Database Name and leave all other properties as it is.
   
9. Click on Test Connection if test successful then hit OK to save the connection manager setting UI.
10. Now, double click on ZS PostgreSQL ExecuteSql Task to configure it.
11. In the PostgreSQL ExecuteSql Task, add the following SQL code to DROP a table if it exists and CREATE a table named pg_equipment in the Sql Statement section.
    You can replace table name from the following code.

    DROP TABLE IF EXISTS playground_equip;
    CREATE TABLE pg_equipment (
        equip_id serial PRIMARY KEY,
        type varchar (50) NOT NULL,
        color varchar (25) NOT NULL,
        location varchar(25) check (location in ('north', 'south', 'west', 'east', 'northeast', 'southeast', 'southwest', 'northwest')),
        install_date date
    );
    

    
12. In the above step you can Select Variable as Sql Source Type.
13. Click OK to save ZS PostgreSQL ExecuteSql Task UI settings.
14. Finally, Right Click on Task and Select Execute Task to run it.

Properties

• PostgreSQL Homepage

• SSIS PostgreSQL Source Adapter
• SSIS PostgreSQL Destination
• SSIS MongoDB Destination Adapter
• SSIS MongoDB Connection Manager