Why SSIS package runs little slower on the first run

When a package is being loaded, the runtime will enumerate all of the connection managers, tasks, and data flow components on the system. It does this by looking in certain directories (under <sql>100dts), and also by looking in COM registry for classes that implement certain interfaces. Because this iteration can take a while, we cache…


Have you checked the MaximumErrorCount in your SSIS Package ?

Recently we came across a case where the customer was running a Data Flow Task that was executing to it’s completion without transferring any data.  We finally figured out the whys. Rather than let the good research go to waste, we’re posting the results here.  Source: SQLServer OLEDB Provider Destination: SQLServer OLEDB Provider Transform: Data…


Configuration changes needed for running SSIS 2008/2008 R2 classes in .NET4.0

Recently we came across a case where the customer was developing a .NET managed application using SQL Server Integration Services (SSIS) object model.  The managed application was behaving differently in different versions of Visual Studio (2008 vs 2010). We finally figured out the whys. Rather than let the good research go to waste, we’re posting…


How to install/enable .Net 3.5 SP1 on Windows Server 2008 R2 for SQL Server 2008 and SQL Server 2008 R2

The .NET Framework 3.5 SP1 (also referred to as .NET Framework 3.5.1) is a prerequisite for SQL Server 2008. SQL Server 2008 Setup for standalone instance will install the .NET Framework 3.5 SP1 if it is not already installed. In Windows Server 2008 R2, the .NET Framework is a feature and installing it is different…


Creating HTTP endpoint fails with 7850 error.

Creating a HTTP endpoint in SQL Server 2005 or SQL Server 2008 may fail with the following error messages: Msg 7850, Level 16, State 1, Line 1 The user ‘domainmyuser’ does not have permission to register endpoint ‘training_sql_endpoint’ on the specified URL.  Please ensure the URL refers to a namespace that is reserved for listening…