SSIS Archives - Page 6 of 6 - SQL Authority with Pinal Dave

SQL SERVER – Introduction to Adaptive ETL Tool – How adaptive is your ETL?

February 17, 2011

I am often reminded by the fact that BI/data warehousing infrastructure is very brittle and not very adaptive to change. There are lots of basic use cases where data needs to be frequently loaded into SQL Server or another database. What I have found is that as long as the sources…

SQL SERVER – Automated Type Conversion using Expressor Studio

November 30, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, SQL Scripts, SSIS

Recently I had an interesting situation during my consultation project. Let me share to you how I solved the problem using Expressor Studio. Consider a situation in which you need to read a field, such as customer_identifier, from a text file and pass that field into a database table. In…

SQLAuthority News – Interesting Whitepaper – We Loaded 1TB in 30 Minutes with SSIS, and So Can You

March 14, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News

Business Intelligence, SQL White Papers, SSIS

We Loaded 1TB in 30 Minutes with SSIS, and So Can You SQL Server Technical Article Writers: Len Wyatt, Tim Shea, David Powell Published: March 2009 In February 2008, Microsoft announced a record-breaking data load using Microsoft SQL Server Integration Services (SSIS): 1 TB of data in less than 30…

SQLAuthority News – Best Practices for Integration Services Configurations

October 25, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Business Intelligence, SQL White Papers, SSIS

Best Practices for Integration Services Configurations by Jamie Thomson This article explains what SQL Server Integration Services configurations are used for, why you should use Integration Services configurations, and what options you have for leveraging configurations. It will also make some simple recommendations that are based on my experiences of…