Re: Only getting few records inserted from millions

2023-09-07 Thread Erik Wienhold
On 07/09/2023 19:14 CEST Anthony Apollis wrote: > The problem is that I am only getting 19 rows inserted into my destination > table. My source has over 5 million rows. What am I doing wrong? Few ideas: * Column dim."IMETA_Entity_Mapping"."Entity_Secondary_Key" allows NULL but the join condit

Only getting few records inserted from millions

2023-09-07 Thread Anthony Apollis
Please assist. I am retrieving data from SAP BW using SSIS. The data is loaded into: CREATE TABLE IF NOT EXISTS system."IMETA_ZTRB_MP$F_ZTBR_TA_BW" ( "Company_Code" character varying(4) COLLATE pg_catalog."default", "Posting_Period" character varying(7) COLLATE pg_catalog."default", "