Category Archives: SQL Server

How to draw a line based upon data values in Dundas Chart – Customizing Dundas Chart using Code Editor (SSRS)

Introduction: Dundas has come up with the adding new abilities to Reporting Services (SSRS) in terms of more featured & customizable controls. Not only they look better with lot of UI options to customize, but also have powerful features which … Continue reading

Posted in SQL Server, SSRS | 4 Comments

Extending SQL Server Reporting Services 2005 with Custom Data Extensions (SSRS)

Custom Data Processing   There are many components of SQL Server reporting services which can be customized as per the requirements & one of them is how data is being fetched/processed. Though, SSRS provides quite a good number of inbuilt data … Continue reading

Posted in SQL Server, SSRS | 11 Comments

Importing data from Excel having Mixed Data Types in a column (SSIS)

When we use Excel (Excel source in case of excel 2003 & OLEDB Source in case of excel 2007) as our data source in SSIS, we come across the fact that SSIS decides over the data type of a column … Continue reading

Posted in SQL Server, SSIS | 30 Comments

How to read a Flat File with data delimited by any wild card character like ‘#’, ‘$’ (SSIS)

Requirement: Generally we deal with Flat Files which are comma (,) separated i.e. CSV files. And in SSIS by making use of ‘Flat File Source’ component we can read them very easily. These files can contain results/data from various sources … Continue reading

Posted in SQL Server, SSIS, Uncategorized | 9 Comments

Multi-language reports in SSRS (SQL Server Reporting Services)

Introduction In this world of globalization, everyone wants to have projects, reports etc being accessed by users across countries/cultures around the world. And thus one needs to support SSRS reports in multiple languages. Different-2 applications provide multi-lingual support in different-2 … Continue reading

Posted in SQL Server, SSRS | 12 Comments

Creating & Using a Package Template (SQL Server Integration Services)

When we create an Integration Services solution, a package (package.dtsx) gets added to the solution automatically. This package uses the default package template, which is empty with no control flow task. Also when we add a new package (SSIS Packages … Continue reading

Posted in SQL Server, SSIS | Leave a comment

Dynamic columns mapping – Script Component as Destination (SSIS)

Requirement: In Data Flow task of SSIS, we have to define a Data Source as well as a destination to extract & load the data respectively. And as per the functionality of data flow task (DFT), metadata of the source … Continue reading

Posted in SQL Server, SSIS | 188 Comments