Posts Tagged ‘SSIS’

Developing custom SSIS component – 9 lessons learned

One of the compelling features of Microsoft SQL Server Integration Services (SSIS) is its extensibility. Although SQL Server comes with a wide array of SSIS components (including different data sources, transformation tasks and logical flow control operations), sometimes there is a need to do something unique in your SSIS package, something that is not supported […]

Time Well Spent in 2015

The end of 2015 is fast approaching, with December looming just a week away. For most people, December is packed with the hustle and bustle of last-minute gift shopping, or end-of-year projections and budgets for 2016. Often in the sway of all this activity, many are so focused on the approaching New Year that they […]

SSRS SharePoint Mode Migration Scripting

I am currently at a client who is attempting to migrate Reporting Services objects from SharePoint 2007 to SharePoint 2013.  There are two paths they can choose for the migration: Copy the files over or do a database-attach upgrade to 2010 then 2013.  Either path they choose they will still have to set the reports […]

Microsoft Cloud BI: Azure Virtual Machines, pt 2

In the last post in this series, we looked at why Azure Machines are the most likely candidate for workable SQL Server-based cloud BI implementations.   Today, we talk turkey about actual limitations and things you need to know as you look at a potential solution in this environment. The first thing to know is that Azure […]

Using DTUTIL to Migrate SSIS Packages

I often use the SQL Server (MSDB) Database to store and execute SSIS packages.  However, I found it cumbersome to migrate multiple packages back and forth from network locations to the MSDB or from the various environments (DEV, QA, PROD).  So, I created a simple script to generate the dtutil commands necessary to quickly migrate […]

EzAPI for SSIS 2012

EzAPI is a set of tools for programmatically manipulating your SSIS packages.  This makes creating those dynamic, metadata driven packages a walk in the park. Or maybe the foothills.  Check it out on Matt Masson’s blog here.  Now for 2012!

ETL better and faster

Having been in consulting for over 18 years, I am often asked by business owners or senior management how they can deliver solutions that are faster and better. They also want world-class products that captivate the customer, in addition to better predictability in the solutions delivered. I have found a way to have repeatable success […]

Best Practice SSIS Naming Conventions

It is very easy for SSIS packages to get messy if you don’t adhere to some strict naming conventions. As a consultant, my job is to try to make the SSIS packages as easy to understand as possible. One way to do this is to make sure to use naming conventions for all your tasks […]

Alternative to the SSIS Slowly Changing Dimension Wizard

Problem Within most BI projects you need to in some way handle slowly changing dimensions in your ETL solution. Be it Type 1, Type 2, they are unavoidable because truncating the dimension and fact tables and reloading from scratch is not an option unless the data warehouse is very small. On most of my projects […]

To SSIS Or Not To SSIS

Microsoft SQL Server Integration Services has some great features and is extremely useful for cleansing and importing data into SQL Server, however; not every situation warrants its use. One instance where I found SSIS to be less useful was when importing a lot (just under 100) of XML source files into a SQL data warehouse. […]