I’m very excited to announce that you can now purchase my latest release book: Knight’s Microsoft SQL Server 2012 Integration Services 24-Hour Trainer. The 24-Hour
Category: SSIS
Using Excel Macro (.xlsm) Enabled Files in SSIS
Recently while working for a client that was running SQL Server 2008 R2 I was tasked with loading an Excel Macro (.xlsm) enabled workbook. If
New SSIS 2012 Expressions
SSIS 2012 has added a few new expression functions and I thought I’d spend a short time detailing each. LEFT The LEFT function believe it
SSIS Project Connection Managers
With the new Project Deployment Model in SSIS developers are gaining the benefit of a new design time only feature called Project Connection Managers. If
Converting to the SSIS 2012 Project Deployment Model
The new project deployment model in SSIS 2012 is the new standard for how packages are created, configured and deployed. Any new packages that are
Upgrading Packages to SSIS 2012
Many of you may now or in the future have the need to upgrade your SSIS packages to the new SQL Server 2012 SSIS. Luckily,
SSIS – Inferred Member Insert in Fact Table Load
Recently while working on a different solution for loading inferred member solution in our fact table load I ran into this article on SQL Server
Passing Values into an SSIS Package at Runtime from Outside the Package
SSIS provide several methods for passing values into your packages at runtime. The benefit of doing so allows you to change the results of the
SSIS to SQL Server Data Type Translations
I have found often when teaching SSIS to others that it can be extremely confusing when you first encounter SSIS data types. At first glance
SSIS Source and Destination Assistants
In several previous posts I have described some of the usability changes that will come with the next release of SSIS. Annotations Data Flow Grouping
SSIS Annotations
I have written a couple quick blogs recently sharing some of the new usability changes for SSIS in Denali. In previous posts I wrote about
SSIS Data Flow Grouping
There have been several usability features that have been added to SSIS in the latest CTP. One of these features is Grouping in the Data
SSIS Resolve References
One of the new features in SSIS Denali that I’m really excited about (Other than the ability to Undo ctrl-z) is the new resolve reference
SQL Server 2012 no DTS support
The end has come! We’ve been told for several years the vNext of SQL Server will no longer support DTS and it appear that that
Devin Knight 