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 ...

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 ...

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 these challenges, many IT pros are looking at bringing in high-speed data interconnects to ...

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 Synchronization Manager in SQL Server 2005: ''The merge process failed to get correct ...

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 FIX: The event information that is generated by a child package does not have a ''User:'' prefix in Integration Services in SQL Server 2005 ...