eshana
Uploaded by
6 SLIDES
177 VUES
70LIKES

Streamlining Data Warehouse Loading and SSIS Package Execution Instructions

DESCRIPTION

This guide explains how to efficiently load data to your data warehouse using SSIS packages, access error logs, and troubleshoot data errors. Includes step-by-step instructions and file paths.

1 / 6

Télécharger la présentation

Streamlining Data Warehouse Loading and SSIS Package Execution Instructions

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Warehouse

  2. Loaded Data In DWH

  3. Ad Hoc Loading of Data to Data Warehouse • Access the data sources folder path: \\192.168.10.13\data_sources\FOXPRO • Access SSIS Package path: \\192.168.10.14\ssis package • Choose the folder of the Package to be run (ex: ADSM sources -> ADSM_PROJECT) • Run the following packages ADSM_EXTRACT -> ADMS_STAGING-> ADMS_TRANSFORM -> ADSM_LOAD

  4. Ad Hoc Loading of Data to Data Warehouse cont. • Access the error log text file for package errors Path: \\192.168.10.14\error_log Look for the text file with the same filename of the run package. (ex: package: adsm_extract error log: adsm_extract.txt) • Check data error by accessing path: \\192.168.10.14\dwreports\REPORTS_ERROR

  5. Scheduled SSIS Package • Access the data sources folder the day before the package is scheduled to run path: \\192.168.10.13\data_sources\FOXPRO • Wait for the email if the run is successful or not. • If successful, Check data error by accessing path: \\192.168.10.14\dwreports\REPORTS_ERROR

  6. Scheduled SSIS Package cont. • If the SSIS package failed check the path given in the email.

More Related