Experiments, tutorials and ideas on developing business intelligence solutions
Hi, Recently an issue attracted my attention where we needed to tame the runaway SQL jobs, where the step in the job to import a file from the FTP source at times would run up to 2 days (which would normally complete in ~2 minutes). Well at times ftp downloads by scripts are affected by Read More …
Ohhh… Well the above words can only describe the pain which I encountered again on a different combination of multi server components authentication of MSBI using windows authentication. Well the set up, I worked with is as follows: So as it goes, I had a chart on SSRS, which sources the data from the SQL 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 …