Recently Pragmatic Works published a White Paper in the form of an SSIS skills challenge. I had a go at the challenge and posted my effort on Github. Happy coding.
Category Archives: SSIS
Problem: Your source data contains a column that should be split in two. In this case there is a name column in an Excel file that contains both the first and last name. The destination database has the first and … Continue reading
A little over a year ago I saw a presentation on NoSQL (i.e. Not Only SQL), and specifically MongoDB. MongoDB is an open source document oriented database, and like many things related to NoSQL it seems to have a buzz … Continue reading