assasafras / git_tutorial

Tutorial
0 stars 0 forks source link

Job Failed: Collections - Monthly 1st (530am) | Step 4 | Email_CollectionsLegalLettersAbove90dExtract #25

Closed assasafras closed 8 years ago

assasafras commented 8 years ago

Message

Executed as user: FLEXIRENT\SysSQLSit. Microsoft (R) SQL Server Execute Package Utility Version 10.0.6000.29 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 5:30:01 a.m.
Error: 2016-10-01 05:30:03.82
Code: 0xC020200E
Source: Data Flow Task Flat File Destination [49]
Description: Cannot open the datafile "\DEVAKL016V\CollectionsData\LegalLettersExtract\LegalLettersExtract_NZContracts90DaysAbove.csv". End Error

Error: 2016-10-01 05:30:03.82
Code: 0xC004701A
Source: Data Flow Task SSIS.Pipeline
Description: component "Flat File Destination" (49) failed the pre-execute phase and returned error code 0xC020200E. End Error

Error: 2016-10-01 05:30:13.99
Code: 0xC002F304
Source: Error Mail Send Mail Task
Description: An error occurred with the following error message: "Unable to send to all recipients. System.Net.Mail.SmtpFailedRecipientException: Mailbox unavailable. The server response was: 5.7.1 Unable to relay". End Error

DTExec: The package execution returned DTSER_FAILURE (1).
Started: 5:30:01 a.m.
Finished: 5:30:13 a.m.
Elapsed: 12.605 seconds. The package execution failed. The step failed.

assasafras commented 8 years ago

Duplicate Issue of #27