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…
Demystifying LAST_VALUE function in SQL 2012
The impetus for writing this blog is the ambiguity existing regarding the documentation of LAST_VALUE() function in books online/ MSDN.Recently I was playing around with new analytic functions of SQL 2012. Was trying to implement the LAST_VALUE functionality when I noticed the…
Implementing Checkpoints in SSIS
Checkpoints indicate a consistent state of a database. This is essential for database to perform actions like writing to log file, truncating log etc.The concept of checkpoints have also been implemented in SSIS packages. Checkpoints will indicate a saved consistent state in…