SurendraThotaMSBIProfessional

we are using webservice task in our ssis package and the package is successful in SSDT . when we created SQL job using that package it is failing with  webserviceTaskException: Service Description cannot be null. to solve the issue 1. we have given access to web service for ssis proxy account  2.we have given access on wsdl file folder  3.we given access to temp folder . Still no luck. So the solution for this . We need to give access to wsdl file also.  

Recently when we are migrating sql server 2008 code into Sql server 2012 we found this error . Msg 402, Level 16, State 1, Line 5 The data types datetime and time are incompatible in the add operator.   we came to know that  we cannot  add (+)  or subtract (-)   datatime and time datatype columns as we do in SQL server 2008 . To perform the same functionality we need to cast the time column to datetime column and then perform your action. Delete LKD from OPS_Schema . Alerting_LatestKPIData LKD inner join OPS_Schema . Alerting_SecheduleConfiguration sc on LKD . KPIName = SC . KPIName WHERE SC . LatestCubeDate > =( LKD . latestDate + cast ( LKD . LatestTime as datetime )) and sc . KPIName not like 'NO_DATA_%'

These are main features we need to consider when we are going for tabular model  against traditional multidimensional model . 1. Actions: Additional tab in Multidimensional Cube designer, which allows few triggers in cube development. Tabular model doesn’t have this feature. 2.Aggregations: Tab in Multidimensional Cube designer, which allows additional aggregations to the cube database. Tabular Model lags in this feature. 3.Custom Assemblies: We can add reference of custom assemblies in Multidimensional Cube but Tabular Model doesn’t have this flexibility. 4.Many to Many Relationships: We have direct option for adding many to many relationships in Dimensions and Facts for Multidimensional Cube design. This is one of the option but in Tabular Model we need to do some DAX manipulation for this implementation else no direct way. 5.Translations: Again a direct option in Multidimensional Cube designer but lack in Tabular Model designer solutions. 6.Data Mining : Data minin