Skip to Content
0
Jul 23, 2019 at 06:55 AM

SAP BW and SSIS connectivity - ArgumentOutOfRangeException is met

133 Views

Dear Members,

I am working in a project where I need to onboard data from SAP BW to SQL server. I am doing this in SSIS. Everything was working fine but suddenly on Friday there was a change in the source system where they added a column of char length 255. So accordingly we have also made the change in our destination and changed the SSIS mapping. But during the SSIS job run through SQL agent we are getting the below warnings for each row in the dataflow total almost 7.1M records. So our log size is becoming huge and the job is failing with out of memory exception. The warning messages are - [SAPBW_SRC_GDWH] Information: ArgumentOutOfRangeException is met: row 24284 total length 500, declared lines per recod 2, actual lines 2 , column 15, offset 377, length 255 [SAPBW_SRC_GDWH] Information: Append blank line: row 24284 total length 750, declared lines per recod 2, actual lines 3 , column 15, offset 377, length 255 Can anyone please help if familiar with the issue?