Integration Services – Knowledgebase

SSIS Solving: Error loading ‘TestPackage 7.database’ : Deserialization failed: The method or operation is not implemented.

14 September, 2010 Roel van Lisdonk 0 Comments 1 category

I was working on an old SSIS project in Microsoft SQL Server Business Intelligence Development Studio 2005 and when I opened a package I got the error: Error loading ‘TestPackage 7.database’ : Deserialization failed: The

SSIS error: Column "…" cannot be found or is not specified for query (13865)

26 August, 2010 Roel van Lisdonk 0 Comments 1 category

When I refreshed a SSIS package OLE DB Source, I got the error: column "test" cannot be found or is not specified for query (13865). This was caused by the fact, that the query contained

SSIS Flat File Source Error: 0xC020200E Cannot open the datafile and 0xC004701A failed the pre-execute phase

3 June, 2010 Roel van Lisdonk 3 Comments 1 category

I was getting an error when importing a csv file, by using the SSIS Flat File Source. Error Error: 0xC020200E at Read Flat File [18]: Cannot open the datafile "". Error: 0xC004701A at Import

Handling empty fields during SSIS CSV import

21 May, 2010 Roel van Lisdonk 0 Comments 1 category

Just a reminder: If you have a CSV file containing the data: DataInColumn1Row1,DataInColumn2Row1,DataInColumn3Row1 ,DataInColumn2Row2,DataInColumn3Row2 DataInColumn1Row3,DataInColumn2Row3, DataInColumn1Row4,,DataInColumn3Row4 and you import the columns using a SSIS package the empty columns will be converted to an empty string

Unit testing SSIS 2008 expressions

21 May, 2010 Roel van Lisdonk 0 Comments 1 category

In Microsoft SQL Server 2008 Integration Services, you can use expressions, see (Integration Services Expression Concepts, http://technet.microsoft.com/en-us/library/ms141827.aspx) in your dataflow tasks. For instance, if you want to import a flat file containing 2 columns: FirstName

How to filter – reject records during Microsoft SQL Server Integration Services (SSIS) import of a flat file

22 April, 2010 Roel van Lisdonk 0 Comments 1 category

If you want to filter – reject records during a Microsoft SQL Server Integration Services (SSIS) import of a flat file, you can use the Conditional Split Data Flow Transformation. If the flat file is

How to calculate the difference in seconds between 2 datetime strings (yyyyMMdd HHmmss) in a SSIS expression

21 April, 2010 Roel van Lisdonk 0 Comments 1 category

If you want to calculate the difference in seconds between 2 datetime strings (yyyyMMdd HHmmss) in a SSIS expression, you can use the following expression: Pre @[User::StartDateTimeString] = “20100420 100000” @[User::EndDateTimeString] = “20100420 101010”

How to add a new column to a flat file connection preserving the existing column mappings in Microsoft SQL Server Integration Services

20 April, 2010 Roel van Lisdonk 0 Comments 1 category

If you created a flat file connection in Microsoft SQL Server Integration Services and the structure of the input files changed (a column is added), you can add a column to you’re flat file connection,

How to resolve: SSIS package won’t stop debugger on script task

19 February, 2010 Roel van Lisdonk 0 Comments 0 categories

When you are on a x64 machine and de business intellegence studio doesn’t stop the debugger in you’re script task on the break points, set you’re package to x86 (Run64BitRuntime = False) to start debugging

SSIS 2008 Script Task using and reference a custom none GAC (not signed) assembly

10 February, 2010 Roel van Lisdonk 3 Comments 0 categories

If you reference an custom none GAC assembly from you’re SSIS 2008 script task, you can get an exception, stating the assembly could not be found. Error Error: 0x1 at Filesysteem opschoning: System.Reflection.TargetInvocationException: Exception

Tag: Integration Services