Job Issue: NZReports - Daily (10 am) - Step 1 - Flexirent Pipeline

assasafras commented 8 years ago

Details

Date 30/09/2016 10:53:36 a.m. Step ID 1 Server SITAKL006V Job Name NZReports - Daily (10 am) Step Name Flexirent Pipeline

Issue

The step is not emailing or generating a file anywhere. Will need to check the SSIS package (PipelineDataExtract.dtsx).

assasafras commented 8 years ago

Issue

Variable [User::_filePath] is incorrect, this variable is used to build [User::_fullFilePath]. Expected Value: "\Flexirent Pipeline\Pipeline Extract\PipelineExtract.txt" Actual Value: "\Reports\WebReports\Sales\DailyReports\Yoobee Daily Report.html"

Solution

Changed the Value of variable [User::_filePath] to "\Flexirent Pipeline\Pipeline Extract\PipelineExtract.txt".
Rebuilt config so changes were not overwritten (this is what occurred earlier, I only changed within the package).

assasafras commented 8 years ago

Ran in SITAKL: Appears to have been successful as the time stamp on the appropriate file was updated as pictured below.

assasafras / git_tutorial