SSIS – what to do if query is slow

I have had a problem at a customer where a source query in a data flow task was slow. I ran the query in Management Studio and it was fast. There was a filter in the query to limit the data for one day, realized with two SSIS Variables passed to the query with the…

1

Be careful with string comparisons in SSIS

I have worked a lot with SSIS the last few months, and in every project with SSIS Icome across the fact that SSIS treats strings with regards to upper andlowercase. Today SQL Server databases are in nearly 99% of all cases installed ascase-insensitive. So you get your data to import from somewhere, directly froma database,…

2

Replication SQL Server to Sybase

I wanted to share some questions I came across during a migration from Sybase ASE to SQL Server 2008. Is it possible to do a transactional replication from SQL Server to Sybase? Yes, it is. You can replicate via the Sybase OLE DB driver, if you set it up as a linked Server. You can…

6

Some hints and tips for the MAPS tool

A few weeks ago I had a small SQL consolidation project. The target was to consolidate five stand-alone SQL Servers (SQL 2000 and 2005) and one SQL 2005 cluster. When consolidating, first of all you must know about the workload on those servers. But how to find out the workload? Spending hours and days in…

0