Destination Table - Condition Amount 0

• yrstruly

  Hall of Fame

  Points: 3475

  More actions

  August 8, 2024 at 4:22 pm

  #4443234

  I need your assistance with an ETL process that runs every six months. Currently, we are in Calendar Year/FY 2025, which started in July 2024.

  The issue is with the "Condition Amount" for FY 2025. Data comes through correctly until the "Insert Data Into Task" step (please see the attached screenshot). However, it appears that the code responsible for the "Update PD Credit" step is not functioning as expected.

  

  The destination table [Turkey - NCD Revenue Reporting Model_Table_Model] is receiving data for FY 2025, but the "Condition Amount" column contains zeros for 2025. Please see the attached sample data for reference.

  To help diagnose the issue, I have included the following:

  DDL for all three tables.

  Insert/Update scripts for the two tasks as depicted in the screenshot above.

  Sample raw data for the two tables.

  Sample data for the "Insert Data Into Task" step. I ran codes below to verify.

  SELECT * FROM [Prod].[Turkey - PD Movements_Table_Other]WHERE  [Posting Fisc Yr/Period] = '001.2025';
  
    SELECT * FROM Prod.[Turkey - LEC invoices raised_table_SAP BW] WHERE [Fiscal year period] = '001.2025'
  

  SSIS can also be found attached for better understanding.

   

   

  Could you please help identify and resolve the issue?

  Attachments:

  You must be logged in to view attached files.

• frederico_fonseca

  SSCoach

  Points: 16152

  More actions

  August 8, 2024 at 4:44 pm

  #4443268

  dup post - see replies on https://www.sqlservercentral.com/forums/topic/destination-table-condition-amount-0-3