Programaticaly executing packages in SSIS 2012 project deployment model

The usual way to execute SSIS packages programmatically was by invoking Dtexec utility until SQL 2012. With the arrival of project deployment model in SSIS 2012 we can now rely upon catalog view and system stored procedures for executing SSIS…

Wildcard based character search using PATINDEX

This is a follow up of the below blog on wildcard character based searchhttp://visakhm.blogspot.in/2013/01/wildcard-character-based-pattern-search.html Extending this further, I did some experiments on how various wildcard characters will work inside pattern in t-sql .Lets see how we can apply similar logic…