I was tasked with importing a .SAS7BDAT file into SQL Server the other day, and there were enough non-intuitive pieces to it that I thought ...

SSIS provides for multiple paths between tasks.  Very helpful stuff; here we’ll look at a simple solution to a common scenario. Below is a ...

There’s no out-of-the-box SQL Compact data source in SSIS, which presents a problem when you’re needing to copy data from a SQLCE data file....

We’ve looked at using transactions in an SSIS package to ensure that, for instance, the read data step in your package doesn’t fail after...

SSIS is used primarily to import data into a database, particularly from flat files, but also from other databases. The typical SSIS packag...

SQL Server Integration Services (SSIS) is a *really* powerful data transformation and import tool; it allows for all kinds of data manipulat...

So when I first started looking into SQL Server Integration Services (SSIS), I was told that the learning curve was steep, and that it was w...

Coming from the Oracle world, I'm in the habit of putting a semicolon at the end of all of my SQL queries. Not a good idea when you...