So you want to use a stored procedure as source (EXECUTE dbo.usp_YourProcedure) in your SSIS data flow but all it gives you is some weird could not determine metadata error… That can be resolved with an easy step – RESULT… Continue Reading
One typical data warehouse or BI problem is keeping the code dynamic and consistent over multiple environments. Say that you have a BI solution and in said solution you have two databases, Stage and DataModel. Every day you truncate and… Continue Reading
For me, working mainly with BI, the MERGE operator is by far one of the most useful ones. Since a lot of the work in a data warehouse is to store data in a structured and organized way the MERGE… Continue Reading
Today there will be a short post of a semi useful query for you who want to monitor your Agent jobs without looking into the standard reports.
This time I thought we can have a look at one way of making your SSIS packages a bit more copy and paste friendly. The assumption in this case is that your source is a SQL Server database and that… Continue Reading