Monthly Archives: May 2012

Quick-Fix: Report parameter with space in SSRS

Khilitchandra's Business Intelligence Blog Posted on by

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 exported report then it becomes less-meaningful for a person who is reading/using the report … probably for some decision making.

Continue reading →

Check if file exists: using SSIS

Khilitchandra's Business Intelligence Blog Posted on by

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 with so this feature is not coming soon. you can check complete story here. Follow these steps: 1. Create a Boolean variable (I call it a Flag_Variable). Assign default value to “False“. 2. Use “Script Task” to check if file exists in given location. And … Continue reading →

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

Khilitchandra's Business Intelligence Blog Posted on by

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. Using T-SQL or through design mode of table etc.

Continue reading →