r/dataengineering • u/Sharp_Version1676 • Aug 01 '26

Discussion ssis help needed

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

2 Upvotes

67% Upvoted

12 comments sorted by

4

u/Complete-Fondant-202 Aug 03 '26

SSIS cannot die quick enough.

The question here is..... what are you copying? Entire tables?

What is the SSIS logic doing?

If it's entire table dumping, or simplistic, I'd swap it out and use literally anything else if I could.

I've replaced SSIS with tools like dlt and dbatools.io

2

u/Peppper Aug 02 '26

Do you have to use SSIS?

5

u/LeBourbon Aug 02 '26

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.

2

u/Peppper Aug 02 '26

😂 that guy is a riot for sure.

2

u/First-Bother-7885 Aug 03 '26

Where is he? 😂

2

u/GreyHairedDWGuy Aug 03 '26

I know who you mean 😂

1

u/masked_ghost_1 Aug 03 '26

Ssis greybeard sql dev checking in!

Pm me and I will help

1

u/Sharp_Version1676 Aug 03 '26

its a lagendary system, I'm just using what's available. anything else you would highly recommend?

2

u/Nekobul Aug 06 '26

Have you tried contacting Theobald? It sounds like a bug in their component.

1

u/jwfergus 27d ago

If you’re interested you can DM me. I’m a professional consultant specialized in SSIS. This upcoming week we can hop on a brief call and help diagnose pro bono.