SQL Server Aggregator

Assigning surrogate keys to early arriving facts using Integration Services

In data warehouses, it is quite common that fact records arrive with a source system key that has not yet been loaded in the dimension tables. This phenomena is known as “late arriving dimensions” or “early arriving facts” in Kimball terminology. When Read More...

Posted Thursday, May 14, 2009 12:26 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off)

Filed under: Development & Programming, ssis, bi, integration services, ETL, Data Warehouse

Ultimate guide to upgrading to SQL Server 2008

For the ultimate guide to upgrading to SQL Server 2008, please refer to the SQL Server 2008 Upgrade Technical Reference Guide . A successful upgrade to SQL Server 2008 should be smooth and trouble-free. To achieve that smooth transition, you must devote Read More...

Posted Monday, December 08, 2008 10:57 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off)

Filed under: ssis, SQL Server Best Practices, SQL Server Analysis Service, SQL Server Reporting Services

Ordered data requires ORDER BY

When you select data out of a database table, it might seem as if the system will give you data in the order of the clustered index that is on that table (assuming it has one), but this isn't quite right. I showed this in the fifth of my T-SQL tips Read More...

Posted Sunday, November 16, 2008 10:05 PM from Rob Farley | (Comments Off)

Filed under: sql, teched, ssis

Design Query in Editor bug

Ok, so real database developers don't use the graphical "Design Query in Editor"... yeah, I know. Sure, there's the odd time when you're typing a query and you don't have an Object Explorer (eg, in SSIS) and a moment of weakness Read More...

Posted Thursday, July 03, 2008 6:28 PM from Rob Farley | (Comments Off)

Filed under: sql, ssis, sql improvements

"No Match Output" in SSIS 2008

The hairy Irishman (his description - I just call him Sacha) is presenting to the Adelaide SQL Server User Group today, talking about improvements in SQL Server 2008 Integration Services. Right now he's talking about the No Match output of the Lookup Read More...

Posted Thursday, June 12, 2008 1:50 PM from Rob Farley | (Comments Off)

Filed under: sql, SQL Server 2008, ssis

SSIS 2008 - world record ETL performance

Using SQL Server 2008 and SSIS 2008 the SQL Server Performance team working with Unisys and SQL CAT have shown SSIS scaling to world record performance! We loaded 1.18 TB in under 30 minutes . You can find more information here: http://blogs.msdn.com/sqlperf/archive/2008/02/27/etl-world-record.aspx Read More...

Posted Friday, February 29, 2008 6:13 PM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off)

Filed under: SQL Server, ssis, ETL

How to get rowcount efficiently within a SSIS package?

I would like to call this as how efficiently you can obtain counting rows in SSIS package. Usual thought would come is @@rowcount or COUNT_BIG functions, but this is not that efficient way to obtain the results. SSIS provides the snippet within its components Read More...

Posted Wednesday, September 05, 2007 6:50 PM from SSQA.net | (Comments Off)

Filed under: SQL Server, databases, table, ssis, package, component, rowcount, requirement

How to enable the SQL Server 2005 Integration Services process to generate a dump file when the process experiences exceptions

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications How to enable the SQL Server 2005 Integration Read More...

Posted Friday, August 31, 2007 5:56 AM from SSQA.net | (Comments Off)

Filed under: SQL Server, Integration, services, process, ssis, kba, exception, file, dump

SSIS Error: Text was truncated or one or more characters had no match in the target code page

This error started generating since last 2 days on a scheduled job that uses SSIS to import content from a flat file. Eventually we found that a derived column within the table and the flat file flow where dates in YYYYMMDD are changed to MM/DD/YYYY format. Read More...

Posted Wednesday, August 29, 2007 5:54 PM from SSQA.net | (Comments Off)

Filed under: SQL Server, error, error log, jobs, ssis, truncated, destination, source, file, scheduled

The "SQL Server:SSIS Pipeline" performance object does not appear in the "Performance object" list after you install Integration Services from a 64-bit version of SQL Server 2005

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications The "SQL Server:SSIS Pipeline" performance object does not appear in the "Performance Read More...

Posted Saturday, August 25, 2007 7:29 PM from SSQA.net | (Comments Off)

Filed under: SQL Server, performance, x64, services, ssis, kba, int

On a computer that has a 64-bit processor, you receive an error message in SQL Server Management Studio when you connect to SQL Server 2005 Integration Services or when you create or edit a maintenance plan

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications Read More...

Posted Friday, August 24, 2007 6:15 AM from SSQA.net | (Comments Off)

Filed under: SQL Server, Maintenance, Integration, SSMS, services, ssis, kba, plan

DTS still alive in 2008?

I was on a call with several other folks the other day discussing "Katmai". The topic of DTS came up. MSFT had indicated that support for DTS would not go beyond SQL Server 2005 in a variety of channels. I can remember the dozens of Upgrade Advisor messages Read More...

Posted Wednesday, August 22, 2007 8:55 PM from Rick Heiges | (Comments Off)

Filed under: SQL 2008, Katmai, dts, ssis, Express

FIX: Error message when you run a SQL Server 2005 Integration Services package that contains a Script Component transformation:”Insufficient memory to continue the execution of the program”

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: Error message when you run a SQL Server 2005 Integration Services package that Read More...

Posted Tuesday, August 21, 2007 5:41 AM from SSQA.net | (Comments Off)

Filed under: SQL Server, script, memory, ssis, kba

High Performance Connectivity for SQL Server 2005 and SSIS

High-speed heterogeneous integration is a challenge for many corporate IT departments today. Most modern IT groups are having to deal with an incredible amount of disparate systems across the organization, coupled with an ever-growing data set. To address Read More...

Posted Friday, August 17, 2007 6:49 PM from SSQA.net | (Comments Off)

Filed under: SQL Server, performance, databases, webcast, ssis, connectivity, web seminar

The following KBAs were recently modified for Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition.

The following pages were recently modified for Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition. FIX: Error message when you synchronize a subscription by using Windows Read More...

Posted Friday, August 17, 2007 6:39 AM from SSQA.net | (Comments Off)

Filed under: SQL Server, ssis, service pack, kba, replication, hotfix, ftp