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 ...
Every business intelligence solution needs data, which might come from a variety of sources and in different formats. Microsoft SQL Server Integration Services, or SSIS, allows you to extract data ...