Archive for category: SSIS

Integration Service Object Name is not Valid Error

09 Apr
April 9, 2012

While trying to migrate my old SQL Server Integration Services (SSIS) packages from the legacy Package Deployment Model project to a Project Deployment Model one, I ran into the following error on some (not all) SSIS package after selecting it for import:

Object name ‘[object-name]‘ is not valid. Name cannot end with a whitespace.

This is a typical frustrating SSIS error message, uninformative and goes nowhere. Hopefully the tip here should help you get around the error in this particular situation.

Read more →

SSIS 2012 Features and the Project Deployment Model

08 Apr
April 8, 2012

With SQL Server 2012, Microsoft has released a major and much needed update to its SQL Server Integration Services, including features that enable much better manageability features, performance tracking (and SSIS performance tuning) features, as well as better (closer) integration with SQL Server Database Engine.

In this post I introduce the new features of Integration Services that are enabled through the new Project Deployment Model, as well as highlight some of the short-comings of this new technology, particularly with regard to Scale-Out and Distributed Processing.

Read more →

SQL Server Maintenance Plan Object Reference Error

15 Mar
March 15, 2012

I was just adding a small Ad-Hoc maintenance plan on our shiny new SQL Server 2012 test boxes, when I received the following error message:

Adding tasks to the maintenance plan failed: Object reference not set to an instance of an object.

This is a short post that goes through some reasons as to why this error message might appear.

Read more →

SQL Server SSIS Custom DLL Folders

17 Nov
November 17, 2011

This is really more of a note than an actual post, but here I give the relevant folders that you need to ensure you have your custom DLLs in when running an SSIS package.

Read more →


22 Oct
October 22, 2011

Until recently I had no idea SSIS allowed opening multiple connections to (flat) files, but due to the performance and parallelism implication of such a connection, I thought its definitely worth blogging about.

Read more →