I saw some recent email about SSIS and SQL Server 2012 Business Intelligence Edition. I thought I would share what I have learned.
It is very easy to misinterpret what one sees in SQL Server Data Tools (SSDT – the new BIDS). When you open SSDT all SSIS components are available, whether or not those components are allowed in your edition of SQL Server. In addition, SSDT will allow you to use and execute these components in the SSDT Environment at design time.
SSIS 2012 BI Edition is Not SSIS 2012 Enterprise
You can build and test an SSIS package using Enterprise-Edition-only components, but you cannot execute this package outside the SSDT environment. Here’s a screenshot of a BI Edition toolbox:
Note the Enterprise Edition-only components: Fuzzy Grouping, Fuzzy Lookup, etc. Take a look at what happens when I execute a Data Flow Task that contains a Fuzzy Lookup Transformation in BI Edition:
Now take a look at what happens when I execute that same package using DtExec on the same virtual machine:
Ugliness. And confusion.