Blog Archives

SSIS Send Mail Task does not support HTML as a message format

I do not use the SSIS Send Mail Task often and either never noticed, noticed and forgot, or never actually needed it myself but this topic came up on a Forum earlier and it caught me off-guard. SSIS has been around

Posted in SSIS

Importing data in a MySQL database into a SQL Server database

Let me start by saying this did not turn out to be as easy as I originally thought. I started with a giant assumption that I think many may have in the past: With SSIS, Microsoft’s integration tool shipped with

Tagged with: , ,
Posted in SQL Server, SSIS

Article Published on SQL Server Central

My fifth article was published on SQLServerCentral.com yesterday: Loginless In Seattle

Posted in Database Security, SQL Server

Iterate Over Databases Using SSIS – Part 2

In Part 1 of 2 I showed how to iterate over the databases in any given SQL Server Instance using SSIS. In Part 2 I’ll show how to extend the SSIS Package created in Part 1 to iterate over all

Tagged with: ,
Posted in SQL Server, SSIS

Iterate Over Databases Using SSIS – Part 1

In Part 1 of 2 I’ll show how to iterate over the databases in any given SQL Server Instance using SSIS. In Part 2 I’ll show how to extend the SSIS Package created in Part 1 to iterate over all

Tagged with: ,
Posted in SQL Server, SSIS

You gave them dbo?

Quite often I hear ┬ápeople say “I made them dbo” or “I gave them dbo” when announcing they granted someone full control of a database. It is quite rare in my experience that anyone would make a Server Login the

Tagged with: ,
Posted in Database Security, SQL Server