Ale, music and enjoying life.
Useful article here runs through the paging mechanism available through the Twitter search API https://dev.twitter.com/rest/public/timelines
Spent a few minutes trying to assign null to a derived variable as part of a script task transform. In my mind Row.CreatedDate = null would do it right? After, making the changes and running the data through again I could see that this…
Haven’t really touched XML for a fair few months now so by way of a refresher I worked through the excellent Pluralsight “Many Approaches To XML Processing” course. Notes below:- Use XmlReader when reading LARGE documents from disk – does not read complete document. very…
Hit an issue recently where a csv file was being transformed through an SSIS package but persisting to the database as zero value integers for all null value columns. Spent time examining table constraints through trying to establish why this was occurring. It’s not the…
Just received the update. You’ll need at least 50% power.