April 10, 2012 at 10:48 am
I figured I'd try it over here also:
Hello everyone: Well, I got with my IS contact and we fixed the package to pull in TotalBranchSales correctly. However, I'm sort of on my own when it comes to getting the syntax right on one of the calcs. Still need help on this if possible.
This is the before calc:
(!ISNULL(ProfitCenterExpenseLeftover) && !ISNULL(CustomerCount)) ? ((DT_NUMERIC,20,10)ProfitCenterExpense + ((DT_NUMERIC,20,10)ProfitCenterExpenseLeftover / (DT_NUMERIC,20,10)CustomerCount)) : (DT_NUMERIC,20,10)ProfitCenterExpense
This is my feeble attempt to change it - as I said not sure about precision/scale values:
(!ISNULL(ProfitCenterExpenseLeftover) && !ISNULL(TotalBranchSales)) ? ((DT_NUMERIC,10,3)ProfitCenterExpense + ((DT_NUMERIC,10,3)ProfitCenterExpenseLeftover * ((DT_NUMERIC,10,3)ProfitCenterExpense / (DT_NUMERIC,10,3)TotalBranchSales))) : (DT_NUMERIC,10,3)ProfitCenterExpense
And here's the dreaded error messages:
Error: 0xC0049063 at Inside Sales Allocation, Total PC Expense [9925]: The conditional operation failed.
Error: 0xC0209029 at Inside Sales Allocation, Total PC Expense [9925]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Total PC Expense" (9925)" failed because error code 0xC0049063 occurred, and the error row disposition on "output column "Derived Column 1" (11222)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
Error: 0xC0047022 at Inside Sales Allocation, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Total PC Expense" (9925) failed with error code 0xC0209029 while processing input "Derived Column Input" (9926). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
Information: 0x40043008 at Inside Sales Allocation, SSIS.Pipeline: Post Execute phase is beginning.
Information: 0x40043009 at Inside Sales Allocation, SSIS.Pipeline: Cleanup phase is beginning.
Task failed: Inside Sales Allocation
Warning: 0x80019002 at Foreach Branch Calculate Inside Sales Allocation: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Warning: 0x80019002 at AllocateInsideSales: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "AllocateInsideSales.dtsx" finished: Failure.
The program '[7836] AllocateInsideSales.dtsx: DTS' has exited with code 0 (0x0).
April 10, 2012 at 11:06 am
HI Lynn: And right, it was shortly after I posted it that it dawned on me I wasn't supposed to do that. Those are basic forum rules - my bad!
But hopefully I'll see a response soon. Getting pressure to get that package going! :w00t:
= )
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply