Monthly Archives: July 2012

A Column Storage Calculator

Posted on July 31, 2012 by

Proper table design requires a clear understanding of business requirement. There are two factor that affects the performance of the database system and storage. one, poor data modeling and two, column data storage. I am not going to talk about the … Continue reading →

Posted in SQL Server | Tagged , , , | 1 Comment

Excel auto column data type detector

Posted on July 30, 2012 by

Excel Source reader task detects the column data type from Excel file automatically. But, this is not always helpful for developer to get the default settings from the excel source component. For instance, if a column in the excel file … Continue reading →

Posted in Excel, SSIS | Tagged , , , , , , , , , | Leave a comment

SSIS and SSRS Template File Location – SQL Server 2008 R2

Posted on July 25, 2012 by

Templates are used to make the development process easier or eliminating repeated work. For instance, the company reports are always having some standard format. if you are asked to design a report in SSRS with your company header image,footer text and … Continue reading →

Posted in SSIS, SSRS | Tagged , , , , , | Leave a comment