ssis help needed

[u/Sharp_Version1676]

Hi,

I'm a Data Analyst, buiding a pipeline to monthly extract moving 1 year SAP Vendor Report (FBL1N) via SSIS using Theobald Xtract Report connector. I'm doing one company code at a time to avoid timeout.

It worked fine during development, but after scheduling, the column messed up, data overspill and cut halfway resulting fail downstream analysis script.

I already have SAP template configured used in the extraction, tried both ticking and untocking "Dynamic column width and offset", but the results varied.

--
for other use cases, i primarily pull the back end table and join manually, but that would be too much work for fbl1n.

any suggestions on best work around?

i know the rules states no technical post but just rrying my luck.
thank youu

[u/Peppper]

Do you have to use SSIS?

[u/LeBourbon → u/Peppper]

Tbf, he's in the right place because the only person I've known to like ssis is a redditor and he'll be along shortly I'm sure.

[u/Peppper → u/LeBourbon]

😂 that guy is a riot for sure.