SurendraThotaMSBIProfessional

Advantage of Parallelism   in ssis 1.        Parallelism is ssis : Parallel Execution improves performance on Systems   that have multiple physical or logical processors. For this   SSIS uses two properties: MaxConcurrentExecutables and EngineThreads. The MaxConcurrentExecutables property is a property of the package. This property defines how many tasks can run simultaneously; by specifying the maximum number of SSIS threads that can execute in parallel per package. The default value is -1, which equates to the number of physical or logical processors plus 2 The EngineThreads property is a property of each Data Flow task. This property defines how many threads the data flow engine can create and run in parallel   Simple Usecase   , where I have implemented Parallelism. I am taking simple work flow which I have implement in my requirement . Need to call the web service   with the values in each row of the   FinalObjects   table. For example : if the FinalObjec

Case Study : When a user want to select the Particular Granularity of time in his report   when the data is coming from SSAS Cube . Granularity : Q – Quaterly   ( for every 15 mins data) H – Hourly D – Daily W – Weekly M – Monthly Y – Yearly Solution : Step 1 Create a Parameter Called Granularity and give the Values as shown below . Step 2 : In Main Data Set Create a parameterized named set   called Peroid   as shown below   with set Period as CASE @Granularity       WHEN "H" THEN   {[Date].[Year -   Month -   Date].[Date].members *[Time].[Time Hierarchy].[Hour].members}                                   WHEN   "D" THEN   {[Date].[Year -   Month -   Date].[Date].members}                                   WHEN   "M" THEN   {[Date].[Year -   Month -   Date].[Month].MEMBERS}                                   WHEN   "Y" THEN {[Date].[Year -   Month -   Date].[Year].members}                    

Problem : When we have Multiple Namespaces in the Xml Source which we need to load the Data from   as we shown below Then we will face a issue in generating XSD for that XML Error : Unable to infer the XSD from the XML file. The XML contains multiple namespaces. (Microsoft Visual Studio) Solution : First we need to avoid multiple namespaces to transform your source file to a format that doesn’t refer to the namespaces. SSIS has an XML task that can do the transformation. 1) Add the XML task to an SSIS   Control Flow and edit it. 2) Change the OperationType property value to XSLT, the SourceType to File connection and the Source to your source file that has the problem. 3) Set the SaveOperationResult property to True and expand the OperationResult branch. Set DestinationType to File Connection and the Destination to a new XML file ( ModifiedInput.XML). 4) Add the below script to a new file and save it with an xslt file extension (Input.XSLT) <

Pulling Data From SSAS using   SSIS Data Flow Task (Error code: 0x80040E21.) Data Flow Source    : OLEDB Source    OLEDB Provider : Microsoft OLEDB Provider For Analysis Services 10.0 Connection String   :   Data Source=cd-as-obi.bgc.net\obid;Initial Catalog=DbMRTG;Provider=MSOLAP.4;Integrated Security=SSPI; General y if we get   this error   : [OLE DB Source [1]] Error: SSIS Error Code DTS_E_OLEDBERROR.   An OLE DB error has occurred. Error code: 0x80040E21. Solution : Just add   Format=Tabular;    in connection string   now the Connection string looks like Modified Connection String : Data Source=cd-as-obi.bgc.net\obid;Initial Catalog=DbMRTG;Provider=MSOLAP.4;Format=Tabular;Integrated Security=SSPI; After Modifying Connection string Save it and Execute the Task

Error code : Code: 0xC002F304      Source: Web Service Task Web Service Task      Description: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not generate the proxy for the specified Web service. The following errors were encountered while generating the proxy: Source file 'C:\Windows\TEMP\2d0vea3n.0.cs' could not be found   No inputs specified   .      at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser)      at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".   End Error   Error: 2010-12-03 11:09:52.72    When it will Occur :   when we are using web service Task in ssis package and that package is used to create a Sql agent Job. Soltion : we need to Make sure that the account that the job is running under (the

1.      Introduction A partition is a container for a portion of the measure group data. Every measure group has at least one partition; this partition is created when the measure group is defined. When you create a new partition for a measure group, the new partition is added to the set of partitions that already exist for the measure group. Partitions are a powerful and flexible means of managing cubes, especially large cubes. Processing a smaller amount of data will improve processing performance by decreasing processing time. It is also very easy to maintain the cube .By default each measuregroup have one Partition but for better processing performance and query performance we need to have multiple partitions based on criteria. The best way to design partition is based on date column.   Dynamic Partitioning is an automation of partition creation, deletion, merging and processing etc.   Without any manual intervention .it will reduce cost as well as human errors for handling t