Executing SSIS 2012 package through stored procedure

Many times we want to run SSIS package programmatically and want to pass parameter through it. In SSIS 2012, we have option to deploy SSIS package in Integration Services server which is an instance of SQL Server database engine. and call it witha  stored procedure. In this article, I am going to show one of the ways on how we can execute SSIS package and provide parameter value using stored procedure.

Continua a leggere

Power BI – Quick Insight

Month Ago Microsoft Release a new features for power bi, Power BI’s Quick Insights.Lately there have been many upgrades in this regard that have greatly improved this feature. IN this article i try to show you what we can do with power bi Quick Insight.

Continua a leggere