SurendraThotaMSBIProfessional

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 )        at Microsoft . SqlServer . Dts . Runtime . ReferenceId . RefIdProducer . ProcessElement ( XmlEleme

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".

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

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 DB Service Components"  Hresult: 0x80040154 

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_SubProjectId_=770

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

we have a requirement to create a Cube where Fact data avialable in Oracle and Dimensional Data available in Teradata which Datawarehouse .  The got the issue when we try to keep Other Relational data source as secondary Data source in SSAS . Please check the actual issue what we are facing when we have multiple datasources apart from Sql server . http://surendrathotamsbiproffesional.blogspot.be/2014/10/ssas-teradata-error-errors-in-high.html we performed the Fallowing tests to confirm . Here are the tests Test 1 : Single Data source   è   Teradata ( .net data provider for Teradata )   è   PASS Test 2 : Double Data Source è Teradata ( .net data provider for Teradata )    as Primary and Sql server as Secondary è PASS Test 3 : Double Data Source è Teradata ( .net data provider for Teradata )    as Primary and Oracle  as Secondary ( Tried with all possible oracle connectors) è Fail                  NOTE : Oracle ( Oledb provider for Oracle ) is not even open in

Problem :  we want to use multiple datasources in our Cube . it is working fine when we use Oracle but it is failing when we use Teradata. with the fallowing error . Errors in the high-level relational engine. The 'DS Name' secondary data source is not a relational data source, or does not use an OLE DB provider. we are using  .Net provider for Teradata . Solution :  Teradata Or Oracle can only be Primary DataSource . So Make Teradata as Primary and Sql server as Secondary . we performed  some tests and come to conclusion . please see the below tests. Here are the tests Test 1 : Single Data source   è   Teradata ( .net data provider for Teradata )   è   PASS Test 2 : Double Data Source è Teradata ( .net data provider for Teradata )    as Primary and Sql server as Secondary è PASS Test 3 : Double Data Source è Teradata ( .net data provider for Teradata )    as Primary and Oracle  as Secondary ( Tried with all possible oracle connectors) è Fail    

When we try to load data into Excel we are getting the comment on each cell like the number in this cell is formatted as text or preceded by an apostrophe ssis to avoid these we did this work around 1. take a template with sample data 2.load new data(it takes same datat ypes as in sample data) 3.remove sample data from target excel Brief decription for the above Steps. 1. Take a Destination Excel format as a Template  with some sample data ( with the format we required ) 2. copy that template to destination location and load the other data into that Excel 3. Then remove the sample data from the excel  using script task .   Please see my previous post on how to delete 2nd row from the excel using script task

we want to Delete the 2nd row from the Excel file where 1st row Contains Headings . Here is the script task component code to delete 2nd row from the Excel . Major Steps : Create Excel.Application Object                      Open work of the Given Excel file                      Open sheet                      Delete the Entire row  of Cell A2   using Entirerow,Delete                      Save The workbook                      Quit the excel Dim filename As String Dim appExcel As Object Dim newBook As Object Dim oSheet1 As Object appExcel = CreateObject ( "Excel.Application" ) filename = "C:\test.xls" appExcel . DisplayAlerts = False newBook = appExcel . Workbooks . Open ( filename ) oSheet1 = newBook . worksheets ( "Sheet1" ) oSheet1 . Range ( "A2" ). Entirerow . Delete () newBook . SaveAs ( filename , FileFormat := 56 ) appExcel . Workbooks . Close () appExcel . Quit ()