Browse by Tags

• BI
• Business Intelligence
• Lookup Transformation
• Performance
• Performance tuning
• Semi-blocking components
• SQL Server 2005
• SSIS
• SSIS Caching
• Transformations
• Union All

• 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 3 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 – 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