4,156
Any clue how to resolve it
*This post is locked for comments
I see you logged a support case for this. I will let the support engineer who grabs it handle this going forward so as not to duplicate our efforts.
Thanks for the reply but the attitude is not good. I posted on main page then I found out that there is also a separate segment for AC. The biggest issue that this site gets changed before one even gets familiar with it. It always takes heck of time to find the things where those are and why those are not appearing at the expected place and by the time I find it the next hurdle is slow and timing out of your site is another painful process like in labor room.
No body has the joy and fun and time to waste to post duplicate
Anyhow those were the last lines I copied when I ran the package from SSIS(MSDB) attached screen shot; though when I ran the agent job the error message is different
Here is the log
Message Executed as user: ??????\administrator. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 32-bit
Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 10:17:31 AM Error: 2015-03-06 10:18:49.77
Code: 0xC0202009 Source: Copy Loc Unit Cost OLE DB Source [1] Description: SSIS Error Code DTS_E_OLEDBERROR. An
OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft OLE DB Provider for
SQL Server" Hresult: 0x80040E14 Description: "Divide by zero error encountered.". End Error Error: 2015-03-06
10:18:49.77 Code: 0xC004701A Source: Copy Loc Unit Cost SSIS.Pipeline Description: component "OLE DB Source"
(1) failed the pre-execute phase and returned error code 0xC0202009. End Error DTExec: The package execution returned
DTSER_FAILURE (1). Started: 10:17:31 AM Finished: 10:18:49 AM Elapsed: 78.796 seconds. The package execution failed.
The step failed.
The text you included here just says there was another error. You need to scroll up the log from the bottom until you find the actual error. A common cause lately for this package to fail is if you have GP set to close to divisional retained earnings. I would check to see if that is enabled. Also, please delete the duplicate thread you posted for this.
#1
André Arnaud de Cal...
292,865
Super User 2025 Season 1
#2
Martin Dráb
231,723
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
