SSIS – Jorg Klein's Blog

BI on your terms with SQL Server 2016

The last few years Microsoft’s strategy was all about cloud first (or cloud only?), releasing new BI products and updates

Last week Microsoft released CTP3 of SQL Server Integration Services (SSIS), code name: Denali. In this blog post I will

We recently had a few customers where a connection to Oracle on a 64 bit machine was necessary. A quick

When watching the SQL PASS session “What’s Coming Next in SSIS?” of Steve Swartz, the Group Program Manager for the

The latest releases of SQL Server contained (almost) no new SSIS features. With the release of SSIS 2008 the ability

Quite often one or more sources for a data warehouse consist of flat files. Most of the times these files

Since my last blog post about a SSIS package design pattern I’ve received quite some positive reactions and feedback. Microsoft

I recently had a chat with some BI developers about the design patterns they’re using in SSIS when building an

Recently I had to create a fact table with a lower grain than the source database. My source database contained

The excel connection manager scans every first 8 rows to determine the data type for a column in your SSIS