SQL Server 2008 Integration Services ships with the wonderful new Data Profiling Task. Much as the name implies, it profiles the data in a given table and returns a ton of useful information. The task ...

I have never used SQL Server Integration Services before and need to extract data out of several Access databases, then transform it and load it into an SQL Server table.<br><br>Migrating data from ...

Do you have a large data import that leaves your indexes less than perfect? Do you want to backup your current database before you run a purge package? You are in luck; SSIS contains a handful of ...

BlueFinity International recently demonstrated how to create a simple SSIS transformation to move MultiValue data into MS SQL Server using mv.SSIS in a free webinar on March 1. According to BlueFinity ...

When it comes to converting data from one type to another in SSIS, you have a few choices. We are going to look at a few of them and discuss the differences. With all of these, we are assuming that ...