Infrastructure at your Service

Integration services Archives - Blog dbi services

Stéphane Haby

SSISDB is too big and it is not every time the retention period’s fault!

By | Database Administration & Monitoring, Database management, Technology Survey | 2 Comments

In all blogs that I read, the solution is just to change the retention period to a reasonable value. Yes, it is true but in some case you need to go deeper in the analysis… Like you, I changed the retention period, ran the cleanup but finally, I had always a big database… Why, Why, Why? My first step for this analysis, is to see in the SSISDB, the Disk Usage by Table Reports from…

 
Read More
Stéphane Haby

SQL Server, Integration Services and Package Versions

By | Database Administration & Monitoring | No Comments

A lot of people ask me about the different versions of SQL Server Integration Services and packages. I create rapidly this little table to summarize it: With SQL Server 2008 and 2008 R2, the SSIS version is the same than SQL Server Integration Services 10.0. With SQL Server 2005, the SSIS version is not contained in the service name. To get this information, you must check directly in the MsDtsSrvr.exe file. How to know your…

 
Read More
Stéphane Savorgnano

SQL Server 2012 SP1: First Cumulative Update (CU1) now available

By | Technology Survey | No Comments

A couple of days ago (20 November 2012), Microsoft rolled out the first cumulative update (CU1) for SQL Server 2012 Service Pack 1 (SP1). It’s just two weeks after the release of the first Service Pack (SP1) we are talking about here. What this first CU for SQL Server 2012 SP1 features: This CU1 contains 44 hotfixes: 33 for the Engine 3 for SSAS 4 for SSRS 4 for SSIS If you want to have…

 
Read More
Stéphane Haby

SQL Server 2012: SQL Server Data Tools (SSDT) – Schema and Data Comparison

By | Database management | 2 Comments

In my life prior to SQL Server, I worked with Visual Studio Team System (VSTS). The “Schema and Data Comparison” feature of SQL Server 2012 Data Tools is a direct descendant of Visual Studio for Databases Professionnals (aka Data Dude) included in VSTS. What is SQL Server Data Tools? These new tools replace BIDS (Business Intelligence Development Studio). But they are more than just relational database development tools. SQL Server Data Tools (SSDT), code-named Juneau,…

 
Read More
Stéphane Haby

SQL Server 2012: Cumulative Update 3 (CU3) now available

By | Technology Survey | No Comments

This week, the third cumulative update was made available on the Microsoft website. What is in this CU for SQL Server 2012? This CU has 36 hotfixes: 25 for the engine 1 for SSAS 4 for SSIS 6 for SSRS To have more information and download it, click here Historic of SQL Server 2012 If you update your SQL Server 2012, you will have a new build version: 11.00.2332 I will give you a quick…

 
Read More
Yann Neuhaus

SQL Server: Attunity connectors for data transfer to Oracle

By | Application integration & Middleware | 2 Comments

Recently, at a customer site, I discovered the Attunity connector 1.1 for Oracle. The customer uses this connector to transfer data from Oracle to SQL Server using Integration Services (SSIS) and informed me that performances are greatly improved. So I decided to post a blog about this connector and perform a benchmark between Attunity connector and Microsoft OLE DB provider for Oracle.

 
Read More