Blog Archives

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

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