Showing posts from July, 2013

SSIS - Error at pull the data from db[Excel Destination [197]]: SSIS Error code DTS_E_OLEDBERROR

This is one interesting error that I got while loading data to excel report. I have created very simple package to copy excel report template from my template folder to destination folder and trying to load data from my database but it throwed below mentioned error.  Fig 0.1  Look at the pacakge in the figure 0.2.  Fig 0.2  It pick the template from the template folder and the file name is shippedReport.xls as shown in Fig 0.3  Fig 0.3  Name of the output file is different from the input template and the name is ShippedSerials_+date.  Name of the file generating dynamically with the help of the variable.  Fig 0.4  Here comes the problem. while executing the task, it will try to find out the destination file is existing in the folder and if it is not able find out the file throws the above mentioned error. We can avoid this issue by making the delay validation propery of loading

SSAS - ignore unrelated Dimensions

It is good to ignore any un related dimension while comparing multiple measure values together. Lets consider below example to explain the use of the property ignoreUnrelatedDimension in cube structure of SSAS. I have Case and installedbase details in the cube. case store all the information about the case created by the customer and installed product stores all the information related to the product. Look at the dimension relations ship as shown in Fig 0.1 Fig 0.1 Person dimension is not related to ZINSTALLBAEproactive measure. Now lets look at the excel sheet below in which I considered count of case and count of installed product for the dimension person. Fig 0.2 Here we can see that Serialnumber count of installed product is repeating. this may confuse the end user to have proper decision. This we can avoid by changing the setting ingoreUnrelatedDimension property of measure group to false as givne in Fig 0.3  Fig 0.