Browse by Tags

• How To's
• Integration Services
• Microsoft
• Persistent Lookups
• Pipeline Scalability
• Product/Patch Releases
• Software
• SQL Server 2005
• SQL Server 2008
• SSIS 2008

• SSIS 2008 – Package Restarting and Checkpoints

  A feature available in SSIS is to mange the restartability of a package following an error. For example, if you have a package with many control flow tasks and one fails, once fixed, you may not want to restart the package again from the beginning. SSIS... Posted Sep 09 2009, 11:32 AM by TomStagg with | with no comments Filed under: How To's, SSIS, SQL Server 2008, SSIS 2008, Integration Services

• SQL Server 2008 Part 2 - SSIS Persistent Lookups

  Over the coming weeks I’ll be writing a number of blogs detailing new features and enhancements to Microsoft’s BI platform shipped with SQL Server 2008. The 1 st series will focus on Integration Services. Altius has completed a number of high data volume... Posted Sep 16 2008, 12:46 PM by ShaunRyan with | with 1 comment(s) Filed under: SSIS, Microsoft, SQL Server 2008, SSIS 2008, Integration Services, Persistent Lookups

• SQL Server 2008 Part 1 - SSIS Pipeline Scalability

  Over the coming weeks I’ll be writing a number of blogs detailing new features and enhancements to Microsoft’s BI platform shipped with SQL Server 2008. The 1 st series will focus on Integration Services. Altius has completed a number of high data volume... Posted Sep 03 2008, 12:07 PM by ShaunRyan with | with 4 comment(s) Filed under: SSIS, SQL Server 2008, Pipeline Scalability, Integration Services

• Q. How do you load a .csv file with 4500 columns?

  I suspect that there is a quick answer to this ... you don't. You revisit the data feeds and make them much more manageable. That's not always possible, however, and recently a colleague and I were set a challenge to load some very wide datasets... Posted Jul 31 2008, 09:57 PM by JohnGamble with | with no comments Filed under: How To's, SQL Server 2005, SSIS

• SSIS Importing from Excel problem

  I recently came across an annoying 'feature' of SSIS when importing data from Excel. SSIS can sometimes completely ignore a column(s) of data in a worksheet. This happens when there is no data within the first 8 rows (default setting), so this... Posted Feb 05 2008, 01:38 PM by bloguser with | with no comments Filed under: SQL Server 2005, SSIS, Microsoft

• SQL Server 2005 SP2 Critical Fix (KB934458)

  The initial release of SQL Server 2005 Service Pack 2 (SP2) contained an issue that caused maintenance plan cleanup tasks to remove data before the specified cleanup interval. Install this update to correct the interpretation of existing cleanup task... Posted Feb 05 2008, 01:16 PM by EdGillett with | with no comments Filed under: Software, SQL Server 2005, SSIS, Product/Patch Releases, Microsoft

• SQL and SSIS Performance Tips - When Sourcing from Views, use a SQL Command instead!

  This makes a massive difference in performance. Rather than using the "Table or View" option when selecting your OLE DB Source, instead use SQL Command and use "SELECT x,y,z FROM ViewName": Reason? "In “Table or view” access mode... Posted Feb 05 2008, 01:14 PM by EdGillett with | with no comments Filed under: SQL Server 2005, SSIS, Microsoft