Posts

SSAS Heterogenous Datasources : SQL Server ,Oracle ,Teradata Combinations

1.    How to use heterogeneous data sources in SSAS 1.1 Introduction              In our Microsoft BI projects we are creating many SQL Server analysis services CUBEs. In General all the Facts and Dimensions are present in one single SQL server instance which is most common design that everybody will fallow .In some cases we need to get the data from two different instances of SQL servers in this case one instance acts as primary data source and other instance acts as secondary data sources in Data Source view (DSV).   In our Telecom data warehouse we have different applications in different relational databases. Most of the mobile traffic data and Transactional data is available in Oracle and remaining Customer, CDR and Historical data in Teradata databases. We have to create near-real time CUBEs which we need to present /Alert data within 5-10 minutes of actual event occur for example if number of cal...
Post a Comment
Read more

SSIS 2012: Error 21 System.ArgumentException: An item with the same key has already been added. at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean)

In SSIS 2012 when we have Project connection manger  and package connection manager with the same name then we will get this error . Error   21   System . ArgumentException : An item with the same key has already been added .      at System . ThrowHelper . ThrowArgumentException ( ExceptionResource resource )       at System . Collections . Generic . Dictionary ` 2. Insert ( TKey key , TValue value , Boolean add )      at Microsoft . SqlServer . Dts . Runtime . ReferenceId . ReferenceMap . Add ( String key , String value , Boolean isExternal )      at Microsoft . SqlServer . Dts . Runtime . ReferenceId . RefIdProducer . AddRefIdAttribute ( XmlElement element , String objectName , String objectId , ReferenceParserState state )       at Microsoft . SqlServer . Dts . Runtime . ReferenceId . RefIdProducer . GenerateRefId ( XmlElement element , ReferenceParserState state ) ...
1 comment
Read more

SSAS : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. (Microsoft.AnalysisServices.AdomdClient). + Solution

Problem : have installed Analysis service on my server machine through remote login from my service account. I am able to open Analysis services from there. When I open SSMS from the same service account on my local machine, I am not able to connect to that Analysis service. It is giving me error by saying : "A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. (Microsoft.AnalysisServices.AdomdClient). A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connection host has failed to respond 10.245.192.111:2382(System)." Solution : Based on my research, the issue was caused by the Browser Service account was changed to the domain account. In your scenario, you can try to connect to the Analysis Service using <Servername>:2383 instead of instance name. Or you can change the Browser Service account to "Local System"....
Post a Comment
Read more

SSAS : 'Void Microsoft.AnalysisServices.Server.Connect(System.String, Boolean)'

Problem : We have a fresh install of WS 2012 and SQL Server 2012 Standard. When connecting to Analysis Services with Management Studio, we get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Error connecting to 'SERVERNAME'. ------------------------------ ADDITIONAL INFORMATION: Method not found: 'Void Microsoft.AnalysisServices.Server.Connect(System.String, Boolean)'. (ObjectExplorer) ------------------------------ BUTTONS: OK ------------------------------ Advanced Information shows: =================================== Error connecting to 'SERVERNAME'. =================================== Method not found: 'Void Microsoft.AnalysisServices.Server.Connect(System.String, Boolean)'. (ObjectExplorer) ------------------------------ Program Location:    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SupportedServers.IsIMBIServer(SqlOlapConnectionInfoBase connectionInfo)    at Microsof...
Post a Comment
Read more

SSIS : The requested OLE DB provider SQLNCL10 is not registered. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".

when we deployed the ssis package which is developed in sql 2008 r2  the connection string of  Sql server OLEDB provider looks like Data Source=Sever\xxxx;Initial Catalog=DbOdsPMT;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;Packet Size=32000;Application Name=SSIS-Package-{866F41EB-2082-4344-B650-4BDDB0CFEC95}Sever\xxxx; But when we call the package in SQL agent the connection string changed  to Data Source=Sever\xxxx;Initial Catalog=DbOdsPMT;Provider= SQLNCLI11 ;Integrated Security=SSPI;Auto Translate=False;Packet Size=32000;Application Name=SSIS-Package-{866F41EB-2082-4344-B650-4BDDB0CFEC95}Sever\xxxx; Due to  this the sql Job is Failing  Source: DbOdsPMT-DRA Connection manager "DbOdsPMT"     Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR.  The requested OLE DB provider SQLNCL10 is not registered. Error code: 0x00000000.  An OLE DB record is available.  Source: "Microsoft OLE ...
Post a Comment
Read more

SSRS : How to Connect SSRS report with Parameters from Front End Application

Here i will let you know how to use the SSRS report from the Front end . i will tell you how to prepare URL part with parameter value . To Preapre SSRS report URL to redirect from the Front end application. First go to Reporting server Reports and click on the Report . Take the URL from the Explorer   ( Note we need to consider Reporting Server URL) Once we got the URL http://ReportServerName/Reportserver_Instance/Pages/Report.aspx?ItemPath=%2fUNICA%2fProject+-+Subproject+Details+Concept+Meeting+View&ViewMode=Detail Then append the Parameter Name and Its value &rs: Command=Render&PR_ShowProject_=false&PR_ShowSubProject_=true&PR_ProjectId_=7661&PR_SubProjectId_=7707 The Final URL looks like http://ReportServerName/Reportserver_Instance/Pages/Report.aspx?ItemPath=%2fUNICA%2fProject+-+Subproject+Details+Concept+Meeting+View &rs:Command=Render&PR_ShowProject_=false&PR_ShowSubProject_=true&PR_ProjectId_=7661&PR_SubProje...
Post a Comment
Read more

SSIS error 0xC0010026 :The task has failed to load. The contact information for this task is "%1"." + Solution

Problem : when we try to load a SSIS package from the server then we are facing the fallowing error . TITLE: Microsoft Visual Studio ------------------------------ Failed to save package file "C:\Documents and Settings\id826821a\My Documents\Visual Studio 2008\Projects\Integration Services Project1\Integration Services Project1\DbOdsPMT-DRA.dtsx" with error 0xC0010026 "The task has failed to load. The contact information for this task is "%1".". ------------------------------ ADDITIONAL INFORMATION: Failed to save package file "C:\Documents and Settings\id826821a\My Documents\Visual Studio 2008\Projects\Integration Services Project1\Integration Services Project1\DbOdsPMT-DRA.dtsx" with error 0xC0010026 "The task has failed to load. The contact information for this task is "%1".". ------------------------------ BUTTONS: OK ------------------------------ Solution : This issue will come...
Post a Comment
Read more