Regular Expression in SSIS

Posted by on Oct 28, 2011 in SQL Server, SSIS | No Comments

Regular Expressions are very useful expressions for text processing there are many usages like validation a text against a pattern or find appropriate parts of text with defined patterns which can be solved with Regular Expressions. To find out more about Regular Expressions read here. Today I find a simple case of such things in ...

Read More

Notify Operator Task – SSIS

Posted by on Oct 3, 2011 in SQL Server, SSIS | No Comments

Messaging is one of the most useful features of SSIS. Actually if you want to make a robust and fault tolerant package you need to design logging on errors and warnings properly. there are some options for send notifications in SSIS; Send Mail Task, Script Task ( scripting exactly any type of message ) and ...

Read More