I’ve worked with SSIS for some time now, but a recent question and post pointed out an expression I’d never used before. We often have a need to split strings and pick out some portion of that string. Sometimes we have a need to pull in everything in the “nth” occurrence of a string. The TOKEN expression can be used to get that particular value.

I wrote about cleaning up the SSIS Catalog a while back, but needed to revisit this recently for a different use and needed something that…

Recently, Kevin Hill (b | t ) posted on getting package errors from the SSIS catalog in a single query as opposed to clicking through…

I was chatting with some other SQL Community members recently and the topic of handling late-arriving members for a warehouse load came up. I figured…

I really appreciate what MS has done w/ the SSIS Catalog. We have built-in logging at a level that wasn’t possible in prior releases, but…

Getting Started I attended Varigence’s BIML Workshop last year prior to the PASS conference and got to learn a little BIML while seeing what it…

A while back I posted an article on handling dates in select statements from MySQL. The idea was that I wanted a quick way to…

Build the project In order to successfully publish your project, it must first be able to build successfully. Start by building your project. Right-click the…

We’ve recently been tasked with converting a lot of MySQL Data into our system from a multi-tenant MySQL Database. We don’t have a fixed schedule…

I don’t know if anyone else has had these sorts of issues, but we work quite a bit with conversions of various source data into…