Tag: Integration Services

Database connectionstring error in Microsoft SQL Server Integration Services (SSIS)

30 July, 2009 Roel van Lisdonk 0 Comments 0 categories

When you use the oledb destination in a SSIS package, you must use the oledb connectionstring syntax, see http://www.connectionstrings.com/sql-server-2008 for more information. If you use the connectionstring: Data Source=Server1\InstanceName1;Initial Catalog=Database1;Provider=SQLNCLI10.1;Trusted_Connection=True;  you wil get the error:

Read More

CustomEvenLogger for SSISPackage Script Task

22 May, 2009 Roel van Lisdonk 0 Comments 0 categories

Imports System Imports System.Diagnostics ‘ This class is used for logging to a customeventlog from a SSISPackage Script Taks ‘ By using a ExceptionCategories enum, we can guide the developers to use structured error messages.

Read More

System.OutOfMemoryException on SSIS Script Task

21 April, 2009 Roel van Lisdonk 0 Comments 0 categories

I created a SSIS package with a script task in it. The script task created a XML file, but consumed more then 256MB of memory. The default value for the MemToLeave setting. MemToLeave is virtual

Read More

SSIS package configuration

10 February, 2009 Roel van Lisdonk 0 Comments 0 categories

We have chosen to use a windows environment variable to hold the path to the *.dtsConfig, which is used to configure the *.dtsx package. – Close all open Microsoft Visual Studio 2005 instances (because changing

Read More