SSIS Doc 3

  

SSIS Package Documentation

Overview / Purpose

The purpose of this SSIS package is to facilitate the movement of files between Sql Source and generated flat files in local system. The primary workflow involves retrieving data from the SQL Server, processing it, and then moving to archive. 

Variables Information

take a screenshot of the variable window and put it here in the document 

Dependency :
No dependency 

Task by Task Explanation

1. Data Flow Task: ProcareEligExtract 

    Data flow has two components source as OLE DB and destination as flat file. In source, Using SQL query to fetch data from the database and load that data into a Flat File. 

    Row Count: We are also counting the total number of rows that are loaded. 

2. Execute SQL Task: Set all Variables

    Title- Set All Variable(Explain here)

    Here we are setting up variables like Archive Path

    Attach a screenshot of the script task, so variable manipulation will be presented in this document.

 

3. File system Task:  Rename The Procare File

    Title - Rename The Procare File

    File we generated in Task 1 Data flow, now we are renaming that Flat file.

    Here our source variable is Rename File and our destination variable is StaticFileName name. please refer to the variable window for all types of variables. 

4. File system Task: Archive Procare Data

     

    Title - Archive Procare Data

    Files we generated in Rename The Procare File, now we are removing file path

    Here the source variable is Rename File and our destination variable is Remove file path. please refer to the variable window for all types of variables. 

5. Execute Process task (Write task)

    Using WinSCP commands, we are opening connecting for the FTP location

6. Email FTP NOTIFICATION/FAILED FTP NOTIFICATION

    Send Notification of Execute Package