The rate of change in the business world is increasing exponentially. Disruptive companies are upending whole industries by introducing new technologies and business models quickly copied and adopted ...

You can work with pivoted data in SSIS package, as if it were just another data set. But it requires the Pivot transformation and jumping a few hoops to get there. The Pivot transformation is one of ...

I am working on a project that requires moving data from a large un-normalized access database to a new well constructed sql server database. I've already gone about moving the access db to Sql Server ...