Recently a colleague of mine came to me with an issue he was facing. He was trying to do mapping of data from a flat file source against a reference table to get the conversion codes corresponding to the incoming…
SSIS Tips: Conditional Processing of Files Based on FileTypes
One of the common requirements that we come across in any data warehousing project is the ability to process different types of files to extract data from them onto our data warehouse. For this purpose SSIS provides a ForEach loop…
SSRS Tips: Displaying Copyright and Trademark Symbols in Report
Recently for one of my friend asked me whether we could display copyright (©) and trademark (™) symbols inside SSRS report textbox. He was dealing in a retail project and wanted to show copyright and trademark symbols along with description…
SQL Agent Tips: Configure Custom Schedule for SQL Agent Job
There have been few instances of late where I’ve seen requests in the forums asking for scheduling jobs using a custom schedule in SQL Server agent. I had given the solution for them in the forums. Thought of sharing it…
T-SQL Tips: Fun with FOR XML PATH
Quite often in T-SQL the first thing that comes to our mind when we hear about FOR XML PATH feature is the ability to concatenate row values using it to create a delimited list of values. I myself had blogged…