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 …

Continue reading ‘Check if file exists: using SSIS’ »

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. …

Continue reading ‘Adding a new column to an existing table??? Check the rules first’ »

Important Fact: Default Logging in SSIS which store log entries in SQL Server

Hi all, Few days back I have posted an article on “Default Logging in SSIS“. You can refer that here. In that article I have forgotten to mention a behavior of “enabling a default logging in SSIS package“. Let me show you what you need to know about this fact. Fact: When you enable a …

Continue reading ‘Important Fact: Default Logging in SSIS which store log entries in SQL Server’ »

Best Practices : Writing Stored Procedures

Hi All, I would like to share a handy list which I found today from my old collection during files clean-up. These are few quick tips that every developer should bear in mind while writing T-SQL codes particularly Stored Procedures. It’s always hard to find the best version of such list but we can definitely …

Continue reading ‘Best Practices : Writing Stored Procedures’ »