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 I'd write down the steps while they still were fresh.
Some searching shows it's a problem with several solutions, but most of what shows up seems unnecessarily complicated, at least, for someone who's used to using Integration Services. It turns out that there's a very easy method for accessing the data in one of these files, and it doesn't require a SAS client. It does require a download from SAS, but that is freely available.
