Experiments, tutorials and ideas on developing business intelligence solutions
Hi In this post I would like to quick share a technique which has often come handy in my day-to-day development work. At times when building SSIS package, I have to connect to S/FTP server to download/upload files and the server rejects the connection being busy, or if I have to loop and wait for Read More …
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 …