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 sees you hit "Build Query" to save some typing, but in general I encourage people to ...

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 Component, and I'm wondering why I had always just accepted that in SQL 2005, rows that ...

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  Also watch for a paper from ...

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 such as using Row Count component, for this you have to create a variable of integer ...

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 Services process to generate a dump file when the process experiences exceptions ...

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. Then the string MM/DD/YYYY is converted to a date in a Data Conversion flow. And finally ...

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 object'' list after you install Integration Services from a 64-bit version of SQL ...

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 On a computer that has a 64-bit processor, you receive an error message in SQL Server Management ...

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 that always appeared.  I just revisited the ''Advisory'' ...

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 contains a Script Component transformation:”Insufficient memory to continue the execution of the ...