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,930 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)
95,886 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,465 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,313 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,134 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,871 reads
The Trash Destination and this article came from early experiences of using SSIS and community feedback at the time. When developing a package it is very useful to have a destination adapter that does nothing but consume rows with no setup requirement. You often want run a package part way through development, or just add a path so you can set a Data Viewer.
2008-05-29
1,183 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Comments posted to this topic are about the item Create an HTML Report on...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Comments posted to this topic are about the item Be Wary of Data
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate,
o_orderkey,
o_custkey,
o_storekey
FROMdbo.orders
WHEREo_orderkey = 3877;