Browse by Tags

• Asynchronous components
• BI
• BIDS
• Buffers
• Business Intelligence
• Code
• Convert String date
• Fully-blocking components
• Lookup Transformation
• Non-blocking components
• Performance
• Performance tuning
• Script Task
• Semi-blocking components
• SSIS
• SSIS Caching
• Synchronous components
• Threads
• Transformations
• Union All
• VB .NET

• SSIS - Decrease your fact table loading time up to 40%

  Replace the multiple "Lookup Error Output" Derived Columns and Union All's with a single Derived Column and get a performance boost...... Posted Oct 22 2008, 04:57 PM by jorg with | with 2 comment(s) Filed under: SQL Server 2005, SQL Server Integration Services, BIDS, SSIS, Lookup Transformation, Semi-blocking components, Transformations, Performance tuning, Performance, Union All

• SSIS - Convert various String date formats to DateTime with the Script Task

  The script below is really nice if you need to convert String dates that come in different (unexpected) formats. Just copy and paste the code in your Script Task (paste the function outside Main() ) and it works right away. Supported date formats: YYMMDD... Posted Jun 12 2008, 02:01 PM by jorg with | with 3 comment(s) Filed under: SQL Server 2005, SQL Server Integration Services, SSIS, Script Task, VB .NET, Convert String date, Code

• SSIS – Non-blocking, Semi-blocking and Fully-blocking components

  How can you recognize these three component types, what is their inner working and do they acquire new buffers and/or threads?... Posted Feb 27 2008, 04:59 PM by jorg with | with 5 comment(s) Filed under: SQL Server 2005, SQL Server Integration Services, SSIS, SSIS Caching, Non-blocking components, Semi-blocking components, Fully-blocking components, Synchronous components, Asynchronous components, Buffers, Threads, Transformations, Performance tuning

• SSIS – Lookup Transformation is case sensitive

  How can you safely use the lookup component…?... Posted Feb 12 2008, 04:34 PM by jorg with | with 3 comment(s) Filed under: SQL Server 2005, SQL Server Integration Services, Business Intelligence, BIDS, SSIS, BI, Lookup Transformation, SSIS Caching