/ftp-to-postgres

An SSIS ETL pipeline that transfers CSV files from FTP server to a Postgres database.

FTP Server to Postgres Data Pipeline

by yourstrulyhb

🛠 About the project 🛠

A project on how to create a SSIS data pipeline which transfers CSV files from FTP server to a Postgres database.

This project is an output from following the 4th episode of 𝗕𝘂𝗶𝗹𝗱𝗶𝗻𝗴 𝗬𝗼𝘂𝗿 𝗙𝗶𝗿𝘀𝘁 𝗘𝗻𝗱-𝘁𝗼-𝗘𝗻𝗱 𝗗𝗮𝘁𝗮 𝗣𝗼𝗿𝘁𝗳𝗼𝗹𝗶𝗼 series by Sir Josh Dev.

🌐 Data Source 🌐

🛢️ Postgres Tables 🛢️

  • OFAC_SDN.CSV --> stg_ofac_sdn

    SELECT * FROM stg_ofac_sdn
LIMIT 10;


  • OFAC_ADD.CSV --> stg_ofac_add

    SELECT * FROM stg_ofac_add
LIMIT 10;


  • OFAC_ALT.CSV --> stg_ofac_alt

    SELECT * FROM stg_ofac_alt
LIMIT 10;


  • ofac_consolidated

    SELECT * FROM ofac_consolidated
LIMIT 10;


📑 Reference Documentations: 📑

✍ TODO: