Shouldn't be a problem. I use a lot of Python in cases like these. As the splitting needs to happen on a smaller dimension file, it shouldn't be an issue...

Yeah, I normally just stick to Python for most looping simply because it's easier to partition out the tasks across multiple machines before it even gets to SQL Server. If...

This is just me, and maybe some will disagree. Creating algorithms that operate within a set of predefined rules is not all that complicated unless those rules become extremely complex...

Sounds like you have either late arriving records in the source system that you're not catching or your extract is not fetching all the records. When it comes to late...

Personally, I've had good experience using a separate DR device that's basically a separate machine that's entire focus is backing up locally and offloading to a external cloud platform for...

If PowerBI cost is worrying you, then it's likely not what you're looking for. I think right now, it's about $9.99 per user where competitors like Tableau used to be...

If the header and files relate to each other, then it may be difficult attaching the second and more headers to their respective headers. I've used Python in the past...