SQL Server 2008 Integration Services (SSIS) provides a flexible and scalable architecture that enables high-performance data extract, transform, and load (ETL). The Microsoft Business Intelligence Center of Excellence has extended SSIS to a metadata-driven platform to more effectively build, deploy, and manage ETL processes in large data warehousing environments.
2008-09-19
3,818 reads
By using SQL Server 2008’s new Data Profiling task, you can do a lot to ensure that data being imported via SSIS is valid, and you can develop a system that can take the necessary steps to correct the commonest problems. Bob Sheldon shows you how to get started with it.
2008-09-18
1,701 reads
Business Intelligence expert Vincent Rainardi brings us a new article that looks at how you can profile your data to understand its values and distribution using Integration Services.
2008-09-03
6,985 reads
SSIS has achieved several new and interesting features in SQL Server 2008. And who better to guide you through them and explain them but Robert Sheldon.
2008-08-28
4,270 reads
SQL Server MVP and SSIS guru, Andy Leonard, discusses Integration Services and some of the tasks and containers that he uses quite often.
2010-02-05 (first published: 2008-08-21)
96,464 reads
The OUTPUT clause was a new feature in SQL Server 2005 that can prove very handy in many situations. New author Gennadiy Chornenkyy brings us a look at how you can add this code to your SSIS packages and retrieve ID values back from the database.
2008-08-18
9,507 reads
In part one of this series from Actuality Business Intelligence, Ira Whiteside brings us a look at building your own SSIS transformation.
2008-07-30
17,375 reads
Use the DTUTIL Command Prompt Utility to Copy / Install / Delete the SSIS Package deployed in MSDB Database to file system
2008-07-09
20,295 reads
This tutorial walks you through the process of adding SQL statements to your SSIS packages and bundling them into logical units of work if necessary.
2008-06-23
4,026 reads
This article describes how to use variables in SSIS to dynamically generate folders and file placement.
2008-06-17
17,930 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Comments posted to this topic are about the item Risk Vs Reward, The never...
Comments posted to this topic are about the item Hyperscale Replicas IV
Comments posted to this topic are about the item The SQL Server Date Magic:...
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers