This is a quick blog post, mainly so I have the code available if I need it somewhere in the future 🙂 Sometimes you need a numbers table (also called tally table) when you’re working with data. It’s a table with one single integer column that contains incremental numbers (0,1,2,3,4,…). In a database, it’s fairly […]
Tag: power query
Thoughts on Power Query and SSIS
Recently I received a very interesting question on Twitter from Jeremy (blog | twitter): @jmarx definitely yes — Koen Verbeeck (@Ko_Ver) July 10, 2015 His question was a response on my earlier blog post What’s the deal with Excel and SSIS?, where I remarked that Power Query will rescue the day since SSIS has a lot of […]