bigator

Archive for May, 2012

Quick-Fix: Report parameter with space in SSRS

Hi guys, One of the most common practices and a wise recommendation is to display selected report parameter(s) in report … may be in header or body of SSRS report. It’s a good reference when you export the SSRS report into available formats (Excel, PDF, Word etc.) Because if you don’t include/show selected parameter(s) in […]

bigatorMay 13, 2012 · bigatorKhilitchandra Prajapati · bigator3 Comments
bigatorTags: , , ,  · Posted in: Business Intelligence, Interview QA, Quick Fix, SQL Server, SSRS

Check if file exists: using SSIS

Hi All, Many times, we have to do this simple checking “if file exists/available .. then proceed” in SSIS operations. And Microsoft did not put any facilities to achieve this task in SSIS with default components. People also have raised this concern to Microsoft, but Microsoft explains that they have more priority works to deal […]

bigatorMay 10, 2012 · bigatorKhilitchandra Prajapati · bigator9 Comments
bigatorTags: , , , , ,  · Posted in: Business Intelligence, Interview QA, Quick Tips, SQL Server, SSIS, Tutorial

Adding a new column to an existing table??? Check the rules first

Hi All, So, you are standing at the gates where you need to add a new COLUMN to an existing table. Well, there are 2 cases: Table is empty Table contains data If “Table is empty” then you are still in design-phase of that table. Add new column whichever the way you know 🙂 E.g. […]

bigatorMay 9, 2012 · bigatorKhilitchandra Prajapati · bigator3 Comments
bigatorTags: , , , ,  · Posted in: General, Interview QA, Quick Tips, SQL Server, Tutorial


bigator