assasafras
commented
8 years ago Issue
CollectionsSMSNoticeForAllAcctsInArrears is not a valid SSIS Package (it existed but it was a husk of a package with barely anything in it.
Solution
I have built the package correctly and deployed it.
Details
Date: 29/09/2016 2:43:24 p.m. Step ID: 6 Server: INTGAKL006V Job Name: Collections - Daily (7am) Step Name: CollSMSNoticeForAllAcctsInArrears
Message
Executed as user: FLEXIRENT\syssqlint02. 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: 2:43:24 p.m.
Error: 2016-09-29 14:43:24.24
Code: 0xC001000E
Source: CollectionsSMSNoticeForAllAcctsInArrears
Description: The connection "PRODAKL004V" is not found. This error is thrown by Connections collection when the specific connection element is not found. End Error
Error: 2016-09-29 14:43:24.25
Code: 0xC002F304
Source: Send Mail Task Send Mail Task
Description: An error occurred with the following error message: "The connection "PRODAKL004V" is not found. This error is thrown by Connections collection when the specific connection element is not found. System.Runtime.InteropServices.COMException: The connection "PRODAKL004V" is not found. This error is thrown by Connections collection when the specific connection element is not found.". End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 2:43:24 p.m.
Finished: 2:43:24 p.m.
Elapsed: 0.172 seconds.
The package execution failed. The step failed.