Date		6/30/2020 10:42:45 AM
Log		Job History (CFAStaging ItemTransformPackage)

Step ID		1
Server		ATL2CFANPV002
Job Name		CFAStaging ItemTransformPackage
Step Name		CFA Staging ItemTransformPackage
Duration		00:00:01
Sql Severity	0
Sql Message ID	0
Operator Emailed	
Operator Net sent	
Operator Paged	
Retries Attempted	0

Message
Executed as user: CFA\Administrator. Microsoft (R) SQL Server Execute Package Utility  Version 13.0.4541.0 for 64-bit  Copyright (C) 2016 Microsoft. All rights reserved.    Started:  10:42:45 AM  Error: 2020-06-30 10:42:46.69     Code: 0xC0202091     Source: Transform CFA SalesItem File to  MX SalesItemMaster File CFA SalesItem File [2]     Description: An error occurred while skipping data rows.  End Error  Error: 2020-06-30 10:42:46.69     Code: 0xC0047038     Source: Transform CFA SalesItem File to  MX SalesItemMaster File SSIS.Pipeline     Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on CFA SalesItem File returned error code 0xC0202091.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.  There may be error messages posted before this with more information about the failure.  End Error  Error: 2020-06-30 10:42:46.72     Code: 0xC0209017     Source: Transform CFA SalesItem File to  MX SalesItemMaster File Get existing record in tbSalesItem [193]     Description: Setting the end of rowset for the buffer failed with error code 0xC0047020.  End Error  Error: 2020-06-30 10:42:46.72     Code: 0xC0047038     Source: Transform CFA SalesItem File to  MX SalesItemMaster File SSIS.Pipeline     Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on Get existing record in tbSalesItem returned error code 0xC0209017.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.  There may be error messages posted before this with more information about the failure.  End Error  Error: 2020-06-30 10:42:46.78     Code: 0xC0047022     Source: Transform CFA SalesItem File to  MX SalesItemMaster File SSIS.Pipeline     Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "Sort by SourceCategoryID" (774) failed with error code 0xC0047020 while processing input "Sort Input" (777). 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.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  10:42:45 AM  Finished: 10:42:46 AM  Elapsed:  0.86 seconds.  The package execution failed.  The step failed.