Author: dataplatformcentral (page 7)

I’ve published a new article on MSDN Wiki which explains how connectionstring details can be extracted from an existing SSIS package.You can find the article in the below link http://social.technet.microsoft.com/wiki/contents/articles/25150.t-sql-retrieve-connectionstring-details-from-a-ssis-package.aspx This approach can be used when you want to audit…

Recently in one of my projects there was a case where I had to transfer the data from flat file to SQLServer table. The file was generated by an automated process at the client side and was FTPed to our…

There are numerous ways in which you can implement slowly changing dimension processing in SSIS. There is also a standard task available in SSIS called SCD Task for this. But the task will cause a performance  bottleneck for large tables.…

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…

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…

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…

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…

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…

Here’s a quick T-SQL tip for you.Suppose you want to swap the year part of a date value in SQL server. Here’s a quick and simple way in which you can do it.Lets consider the below example DECLARE @DateValue datetime ,@SwapYear…

I’ve added a new utility function in Technet Wiki to retrieve the number of week day for the month for the date passed ie say 13 Apr 2014 is 2nd Saturday,15th jan 2013 is 3rd Tuesday  etc. Do check it…