Experiments, tutorials and ideas on developing business intelligence solutions
Hi, A one more quick issue I came across at work during my SSIS deployment experience, is when I was trying to deploy my ISPAC (and similar error when I was trying to export the deployed package from SSISDB catalog), is the following error: And the way around the above, was made possible was by Read More …
Hi, Recently while deploying an SSIS ISPAC (developed on my local machine) on to server (Win2012) I encountered the following error on the SSIS deployment wizard: And after little head scratching I found the resolution out to be as follows: And voila, all green on my SSIS deployment wizard… To read more about the database Read More …
This is a short post just to highlight a small setting which is critical to the task at hand !!! I was trying to import cube data (MDX query result set), to my SQL table. So I set up my MDX as usual with an OLEDB connection to the cube (source), and similar one for Read More …
Hi, Is it Reporting… Is it Planning… Can you classify, what system is yours…. Well sorry for my sarcasm, but indeed its a question which at times is not very clear in the objectives of the business when they are mentioning their BI systems. Reporting: As system which collates data from multiple (or) single source Read More …
Hi, Recently stumbling upon the SSIS double hop authentication issue and figuring it out (after a lot of head scratching). The solution I adopted to over come the issue is posted out as follows: Loading and Running a Remote Package Programmatically (MSDN) – What is Double Hop Authentication Issue with SSIS ? This article can Read More …