Author: dataplatformcentral (page 8)

The impetus for this post comes from a recent conversation I had with one of my colleagues. He asked me whether we could implement logging conditionally for a SSIS package. I told it should be possible keeping in mind that…

This is a really quick tip in Excel while opening CSV filesYou’ve different methods available for the data export to csv like bcp,OPENROWSET etc.One issue that I came across recently in this was the CSV file after getting generated, if…

Thanks to Erland I learned a cool way to validate integer or decimal values from varchar field having intermixed data which I’m sharing through this blog.ISNUMERIC was a function which was always thought to be unreliable due to various formats in…

The purpose of this post is to clear the confusion regarding the behavior of Top N & Bottom N filter option available in SQL Reporting Services (SSRS).Couple of days back I came across a post in one of the public…

This blog is to explain a limitation with CASE ..WHEN construct when used in a linked server query which I recently came across.So the scenario was this. I had a table in a remote SQL Server instance from which I…

Recently in one of my reporting projects, we required generating a list of business weeks along with the start and end dates for a given month so as to consolidate the data and do some weekly calculations on it.  I…

Here’s a quick tip regarding SSIS development using SQL Server Data Tools 2012Couple of days before I heard one of my fellow teammates complaining about difficulty in identifying type of precedence constraint in SSIS like whether its for success,failure etc.…

So here’s another SSMS Object Explorer tip for youThere was a question asked in one of the forums couple of days back.In SSMS object explorer you’ve the option to Edit and Select records from a table The question was whether…

Recently there was a SSIS challenge that was brought up by one of my fellow colleagues in his project. The project involves importing data in the form of flat files daily.Some cases the file is found to have duplicate data…

Many people use the table designer component in SQL Management Studio for creating and altering objects in SQL Server. I’ve never used it and I’m more comfortable in using T-SQL queries for doing these activities. Anyways many of my colleagues…