Category Archives: SQL Server

How to prevent SSIS package creating empty flat file at the destination

It’s very common that SSIS package is developed to generate some output as Flat File (.csv, .dat, .txt etc) by using Flat File Destination component. Content of the same can be sourced from either SQL Server database, some other flat … Continue reading

Posted in SQL Server, SQL Server 2008, SSIS | 1 Comment

Database Partitioning into SQL Server / Data Archiving using partitioning mechanism (Part 2)

In part1 of Database partitioning we talked about why we need it and how to implement it into SQL Server database. Also, we have seen how to add new range & filegroups to the existing partitions. Now, in this article, … Continue reading

Posted in SQL Server, SQL Server 2008 | Leave a comment

Database Partitioning into SQL Server (Part 1)

While working on large database/tables we come across several issues – may be queries running slow i.e. data performance issues, time to perform certain maintenance operations and replicating/deleting data from these tables. And to deal with these tailbacks, we think … Continue reading

Posted in SQL Server, SQL Server 2008 | 1 Comment

DELETE vs TRUNCATE – SQL Server

Although this is a very simple question that ‘what is the difference between using DELETE vs TRUNCATE statements in SQL Server’, & both are being used very frequently serving more or less the same purposes, but there are various aspects … Continue reading

Posted in SQL Server, SQL Server 2008 | Leave a comment

Replicate/Migrate data from one database/table to another – Part 3

As we discussed in Part 1/Part 2 about the very simple approaches of migrating the changes from one data table to another, but depending upon the situations, data volume etc., there are a few improvements needed in those approaches. In … Continue reading

Posted in SQL Server, SQL Server 2008 | Tagged , | Leave a comment

Replicate/Migrate data from one database/table to another – part 1

This is about a very simple though very useful and frequently used requirement to replicate/merge data from one database/table to another. There can be various scenarios wherein we do get data from multiple sources into one database/table and then we … Continue reading

Posted in SQL Server, SQL Server 2008, Uncategorized | 2 Comments

How to remove duplicate records from Flat File Source (SSIS)

Problem: Since populating the data warehouse or any other database may involve various disparate source-types like SQL Server, Excel spreadsheets, DB2 etc. It can also be a Flat File/CSV file source as well.  In case of data sources like SQL … Continue reading

Posted in SQL Server, SSIS | 10 Comments