Intergration Services
Jan 26, 2006Does anyone know any good resource sites on Integration Services ?
View 1 Replies
ADVERTISEMENT
Intergration Services Comportant
Sep 19, 2007Can you creat a SSIS package and run the package without installing the SQL server intergration services?
During the SQL server installation, you can choose which component you want to install ( SQL server services, intergration services, and analysis services, etc..)..
I didn't check to install the intergration services comportant..but I can still be able to create a intergration services project thru the business intelligent studio... ( but i don;t see it under SQL server configuration maanger)
what the intergration services if for? is it seperated from SQL server services.. why i can still create a SSIS package even though i didn;t install the intergration services?
MS Management Studio And Intergration Services
Aug 8, 2007Windows Server 2003 x64 SQL 2005...when I open managment studio and try to open intergration services I can see the local machine that I want to connect to however, I get an error when trying to connect...it says that I need to register a library but doesn't list anything about which library...I have logged into the server as the local admin and am part of a domain w/ my ID added to the admin group and cannot connect w/ either...I can connect to the DB and edit etc under sa...have given the proper accesses to the DB but still cannot connect to the intergration services...Any clues? I am trying to schedule jobs to run against the database...or if there is another way to schedule these w/o going through this that would be great as well.
Thanks in advance,
HJM
Sql 2005 Intergration Services Installed But Service Isn't There
May 8, 2007I am a bit out of my league here so any help would be greatly appreciated.
On a Windows SBS 2003 R2 server. I am trying to add Integration Services at the request or an external Consultant group. I ran the install & followed the bouncing ball from this article
http://msdn2.microsoft.com/en-us/library/bb326043.aspx
The only odd thing is that it didn't give the option to pick an instance (only Microsoft SQL Server 2005).
It seems to install fine, no pop up error or anything but the SSIS service isn't installed. If I try & connect to it via the SQL Server Management studio - Selecting Integration Service in Server Type I can browse for the server name but on connecting it says " Connect to SSIS service on machine "Riley" failed
The specified service does not exist as an installed service.
& looking through the list of Services I can't find it.
I have uninstalled Integration services & reinstalled twice now but the same result (no service) ... what am I doing wrong, it seemed so simple from the instructions.
What Other Associated Tools SQL Server 2005 Intergration Services Can Work With?
Sep 8, 2006Hi, all,
Thank you very much for your kind attention.
I am having a question which is: What other associated tools/environment SQL Server 2005 Integration Services (SSIS) can work with? (like we know SSIS can work with other components of SQL Server 2005, Excel,XML files etc.), so what other tools it can work with?
Thanks a lot in advance for any guidance and advices for that.
With best regards,
Yours sincerely,
RUN Intergration Services Deployment Manifest Through Command Prompt
Jun 26, 2007Hi, I want to run "Intergration Services Deployment Manifest" through the command prompt, passing the values .. which should basically go and install that Package either on File System or SQL Server. Does any one have any idea on how to do that ...
Thanks,
Where Is My Intergration Service?
Aug 17, 2007Hi there,
I forget if i've intalled intergration service when i intalled my sql2005. Now cases is that: I cannot find "intergration services" thru "control pannel-->administratcive tools-->services" while i have an "Intergration Service Project" option in Visual Studio 2005--> create new projects-->Business Intelligence Projects. I'll really appreciate if somebody can give me the right direction. thanks in advance
Need Experts On Vb.net CLR Intergration Problem
Feb 5, 2007Hi all I have the following CLR stored procedure :
Partial Public Class StoredProcedures
<Microsoft.SqlServer.Server.SqlProcedure()> _
Public Shared Sub sssGetActiveRepositoryByTitle( _
ByVal title As String)
' Add your code here
Using conn As New SqlConnection("context connection=true")
Dim objCommand As New SqlCommand()
Dim TitleParam As New SqlParameter("@Title", SqlDbType.VarChar, 100)
TitleParam.Value = title
objCommand.Connection = conn
conn.Open()
'build the delete command
objCommand.CommandText = _
"select * from sstRepository where IsActive = 1 and Title =" & TitleParam.Value.ToString
SqlContext.Pipe.ExecuteAndSend(objCommand)
conn.Close()
End Using
End Sub
Now I have a windows service in my data layer that needs to access this stored procedure and convert it into a dataaset to pass to the client application :
Imports System.Data.SqlClient
Imports NBS.SURVEYSDATABASEservice.DBMS
Public Class clsClient
' it inherits the stored procedures from the DBMS class which is the name
'of the CLR dll
Inherits StoredProcedures
Public Function GetClientByVirtualPath(ByVal pstrVirtualPath As String) As DataSet
Try
Dim i As SqlDataReader
'parameters are stored in an array (zero based) for use in the base class
Dim parmArrSqlParms(0) As SqlClient.SqlParameter
' Dim fff As Int32
i = sdsGetClientByVirtualPath(pstrVirtualPath)
' Return MyBase.RunProcedure("dbo.sdsGetClientByVirtualPath", parmArrSqlParms)
Catch ex As Exception
'log the error
'cLogger.LogMessage("ACME", "SampleApplication", Logger.EntryTypes.RunError, System.Environment.MachineName, "clsDemoClass.SelectAllCompanies", ex.Message)
'raise the error to the caller for handling
Throw ex
End Try
End Function
I've tried a bunch of different things to no avail the error I keep getting trying to access the sqlpipe resulsts is " this expressions does not return any values"
any ideas ? I am basically converting around TSQL 50 stored procs into managed CLR code and the CLR funtions are created but I am really having problems accessing the resuluts on the client end .
Help please !
VS 2005and SQLserver Express Intergration
Dec 13, 2005Hi,
View 1 Replies View RelatedSQL 2005 SP2 Reporting Services And Window SharePoint Services V3 Integration Config Issue
Mar 23, 2007Hi,
I have just install SQL 2005 SP2 and trying to get Window SharePoint Services V3 integrated with SQL 2005 SP2 reporting services.
In SharePoint Central Administration, I select the Reporting Services Integration page and have setup the Report Server Web Service URL and Authentication Mode. I then goto Grant database access, specify the SQL server name, get promted for a username and password that has access SQL Reportserver and get the following error "The group name could not be found"
Does anyone have any ideas?
Thanks
Analysis Services 2005 Database Processing Fails When Run From Integration Services
Oct 11, 2007Hello, I have a problem when trying to fully process an SSAS database using Integration Services "Analysis Services Processing Task" task. I have 2 of these tasks which are responsible for processing the Dimensions then the Cubes. When I run the package either via the BIDS environment or on the local server from the Integration Services engine, I will get an error after about 20 minutes stating:
"Error: Memory Error: Allocation failure. Not enough storage is available to process this command""Error: Errors in the metadata manager. An error occurred when loading the <cube name> cube from the file \?D:Program FilesMicrosoft SQL ServerMSSQL.2OLAPDataMyWarehouse<cube file>.xml"
The cube name is not specific, it will fail and any of my cubes could be in the error log
If I fully process the AS database using the AS engine (logon to local AS server, right-click AS database and click Process), I get no errors at all, it processes and completes fine. The processing options are identical when I run in AS or via the SSIS "Analysis Services Processing Task" task.
I've searched quite a lot online but no joy, the information I have gleaned from various sites does not directly link SSIS with SSAS processing problems.
When either the AS processing starts via SSAS or SSIS the memory usage of MSMDSRV.exe increases to around 1.4 / 1.5 GB but never goes to 2GB ever, even when the error appears.
I've done the following with no effect.
" Have run via AS and works fine
" No specific cube it fails on
" Have created a Dimension only package, same problem
" Changed the maxmemorylimit
" Changed the connections to localhost
" Memory DOES NOT max out on server
Server Specs:
Windows Server 2003 Standard + Service Pack 2
4GM ram, 2GB paging file
SQL Server 2005 + Service Pack 2
Can anyone help?
Andy
Reporting Services :: SSRS 2008 R2 - HTTP Error 503 - The Services Is Unavailable
Jul 23, 2010We built our prod server [vm] with SQL Server 2008 R2 on Server 2008 R2. It works nicely. Then we made a copy of the VM and renamed it (so our test environment would be IDENTICAL to production). After that, SSRS was broken: I get "HTTP Error 503. The service is unavailable." I can't connect via http, or SSMS.
We have tried:
* Running SSRS config tool (several times)
* Running with/without the IIS Server Role
* Dropping & recreating the SSRS keys
* Recreating the ReportServer database, etc
* Checking all of the accounts, permissions, etc
* Running SQL Repair
* Going through the registry to fix any references to the machine's old name
* Uninstalling, reinstalling SSRS
* Completely uninstalling ALL of the parts of SQL Server 2008 R2, deleting all directories, removing references to SQL Server from the registry, rebooting, reinstalling everything.
None of this has worked. SSRS [R2] is still 503 on our test box.
the SSRS [NT] service seems to run, without error. The Event Viewer doesn't seem to be recording any errors. The SSRS logs say that the default URL is wrong, but we get the same error in Prod, and Prod works fine. The other SQL Logs say something about not being able to contact the service. However, as I said, the [NT] service seems to be working fine.
Reporting Services - Analysis Services - Displaying Dimension Members As Columns
Dec 3, 2006I think I've seen a similar post on a blog or on the forums - but it seems like this should be possible -
I have an MDX query - that works fine in SQL Enterprise Manager, and has my dimension members on columns, and my measures on the rows. When I try the same query in Reporting Services, I get the error:
"The query cannot be prepared: The query must have at least one axis. The first axis of the query should not have multiple hierarchies, nor should it reference any dimension other than the Measures dimension..
Parameter name: mdx (MDXQueryGenerator)"
Although it works when you pivot the view, I really need my data presented with the members on the columns and the measures on the rows. Another forum post mentioned using the SQL 9.0 driver, but I can't see this listed anywhere (the only one I see is the .NET framework Data Provider for Microsoft Analysis Services).
Here's what my query looks like -
SELECT
{ [Time].[Month].&[2006-09-01T00:00:00] ,
[Time].[Month].&[2006-10-01T00:00:00],
[Time].[Month].&[2006-11-01T00:00:00],
[Time].[Month].&[2006-12-01T00:00:00]
} on COLUMNS,
{
[Measures].[Unique Users],
[Measures].[UU Pct 1],
[Measures].[UU Pct 2],
} ON ROWS
FROM [Cube]
Any ideas?
Thanks,
Arjun
Web Services Task Editor: The Input Web Services Description Language (WSDL) File Is Not Valid
Mar 14, 2006I am trying to prove I can use SSIS to connect to a web service. The WS I am trying to connect to was developed by a vendor and covered by a NDA, but I was able to reproduce the issue with a public WS.
Here are the steps to reproduce the issue:
In the Web Services Connection Manager, I entered http://office.microsoft.com/Research/Providers/MoneyCentral.asmx?wsdl in the URL window. I am able to successfully "test" the connection
I pasted the above link into IE and saved the resulting XML as a .wsdl file on my local machine. In the Web Services Task Editor, General Tab, I specify the path to the .wsdl file and click on "Download WSDL" button. No Issues
When I click on "Input" and select "MoneyCentralRemote" from the drop-down for Service, I receive an error message saying "This version of the Web Services Description Language (WSDL) is not supported"
So the questions are:
Did I perform the above steps correctly?
What WSDL versions are supported in SSIS?
How can I tell what WSDL version was used to create the .wsdl I am trying to access?
If the WSDL is an unsupported version, is there a work-around to fix the issue?
Analysis Services 2000 + Reporting Services 2005 + Parameters
Sep 16, 2007
Hi All,
I'm trying to create reports in RS2005 using AS2000 as my data source. I understand that if I use RS2005 on AS2000, I wont be able to enjoy the OLAP based parameters as in using AS2005. Does anyone know an easy way to easily use Parameters in RS2005 while still using AS2000?
Regards,
Joseph
Error Programaticaly Rendering A Report Using Reporting Services Web Services
Dec 19, 2006I'm using Reporting Services 2005 SP1 and wrote some code to render reports server-side.
My sample report has few parameters that must be passed so I pass these parameters with code.
<My code>
ReportServiceExecution.ReportExecutionService rs = new ReportServiceExecution.ReportExecutionService();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
string extension, mimeType, encoding;
ReportServiceExecution.Warning[] warnings;
string[] streamID;
ParameterValue[] parameters = new ParameterValue[2];
parameters[0] = new ParameterValue();
parameters[0].Name = "pID";
parameters[0].Value = "6548747";
parameters[1] = new ParameterValue();
parameters[1].Name = "pClass";
parameters[1].Value = "8";
ExecutionHeader header = new ExecutionHeader();
ExecutionInfo executionInfo = rs.LoadReport(reportPayslip.Name, null);
executionInfo = rs.SetExecutionParameters(parameters, "en-us");
rs.ExecutionHeaderValue = header;
rs.ExecutionHeaderValue.ExecutionID = executionInfo.ExecutionID;
byte[] report = rs.Render("PDF", "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>", out extension, out mimeType, out encoding, out warnings, out streamID);
</My code>
Actually, I have several more parameters but I've checked the collection and all the parameters I want are there and have values. Their names match those found in executionInfo.Parameters. But when I run my code I get the following error on Render():
<Error>
"This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value. ---> This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value. ---> This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value."
</Error>
I've double-checked and my parameter array does have the problematic parameter, I passed it a value but when I check executionInfo.Parameters I see that it's the only parameter that hasn't been give a default value after calling SetExecutionParameters(). So my parameters do seem to be passed but one seems to refuse getting a value. If I comment out the SetExecutionParameters() line I get, as expected a similar error but on another parameter (first one in the executionInfo.Parameters collection). So I'm left to beleive that the SetExecutionParameters() has some kind of bug as it works for all but one parameter. I've checked casing, spelling, tried passing phony parameters and from what I've seen I should be getting an error when I pass the parameters if I got something wrong.
Any help would be much appreciated.
Using ReportViewer Controls In A Jsp Application Calling Reporting Services Using Web Services
May 29, 2007 Hi,
I am invoking RS web services to render reports, using Apache Axis to generate stub classes from Reporting Service WSDL.
Please let me know if I can integrate Report Viewer control in the jsp where I am writing the report output. Else do I have to create my own custom tags simulating ReportViewer functionality.
Parameters In Reporting Services And Data Source Is Analytical Services
Dec 10, 2007
My requirement for the parameter is multivalue parameter with a text box. for example when user enters aa15 it need to include product aa15. when the user enters aa15, aa16, zz15 than it needs to include all the three products. the last case is when the user enters AA** than i need to inclued all the products start with AA. when i use default multivalue parameter with data source analytical services than i am getting a drop down box. I dont want that. I need a text box where user can enter the value.
1. In sql we have a like key word to query . for example select * from product where product like "AA%".
what is equavalent mdx query to get such results ?
2.How to impliment the multivalue parameters without using dropdown box?
Reporting Services :: PPS (Performance Point Services) Filter Does Not Refresh
Aug 6, 2012I am facing sever Refresh issue in PPS Reports. I have Two Dashboard
Dashboard_One and Dashboard_Two
I have few Filters on both the Dashboard .
In Dashboard_One I have 2 Filters
1)Year filter where Year 2012 is my Default value
2)City Filter where "CityOne" is Default Filter Value
If I select Year"2010" in Period Filter and "CityTwo" In City Filter.I see Related reports . Now I navigate to Dashboard_Two to See Other Reports where I have few Other Filter Like "Country" where I select "CountryThree" . When I navigate Back to Dashboard_one I do not see Dashboard with Default value given to them
I still see Filter value Year=2010 and CountryFilter="CountryTwo" in Dashboard Dashboard_One .. where as I should have seen it based on the Default value given to the Filter.. How should I resolve this refresh issue which I am facing in PPS Dashboard. I do not see Default value in the Filter ,It always give the filter value which was selected later when Navigated back.
Reporting Services :: Error When View Reports Or Manually Processing TFS Data Warehouse And Analysis Services Cube
Apr 24, 2015I am trying to configure the reporting for TFS using SQL Server. But I get following error when viewing any report:
So I try to manually process the cube to check if it works. I am following this article: [URL] ....
When I click on GetProcessingStatus and invoke it (with last field set as TRUE) I get following error:
How to resolve this issue and be able to see the reports.
Reporting Services 2005 And Analysis Services 2000
Jul 30, 2007
Hello,
i have a small problem with the data sources in the reporting services, maybe you can clarify the situation... I have a MS CRM 3 solution with the reporting services 2005 installed. From an other vendor we have a arcplan solution on the 2000 analysis services. I would like to get access from the 2005 reporting services to the 2000 cube. Is this possible? Ive read that the SSMS cant connect to the 2000 cubes. Can i connect from the reporting services??
thank you
regards
Andreas
Reporting Services + Analysis Services Data Source
May 15, 2007Hi all,
Till now all the reports for our application was created in Reporting Services 2005 with SQL Server Database(OLTP) stored procedures.
Most of the reports take 10 to 15 report Parameters and all are multi valued.
Now because of the slow response time,we have decided to use OLAP cubes data source. We have created the OLAP cube in Microsoft Analysis Services.
Can someone tell me how to use the report parameters to query the Cube.
Any links,books for reference would be of great help..
Thanks,
Looking forward to your replies
Sql Server Reporting Services And Analysis Services?
Jan 27, 2004Hi
What is the diff between the above 2?
Thanks.
Reporting Services Authenticating With Analysis Services
Jan 24, 2007Setup: Reporting Services and Analysis Services are on the same server. Active Directory User. Default configuration of Reporting Services.
Problem: Reporting Server does not apply Analysis Services Role after login.
Details:
I have created a report that retreives data from the Analysis Service. I created a role and added my user company/myUserName to the role.
On the Reporting Server I set the data source to :
* Credentials supplied by the user running the report
and
Use as Windows credentials when connecting to the data source
Internally when I connect devsql2005/Reports/ReportName I get the user and password fields. When I fill them in I get the report but I can see all the data while my role was restricted to see only few results.
Can anyone suggest what may be wrong? Any articles or tutorials on how to setup and deploy solutions where Report Server is talking to Analysis Services and NOT Sql Server.
Thank You,
Pavel Hlobil
SQL Browser Services Not Present In The Services List
Mar 4, 2008
Hi,
I am trying to install SQL 2k5 on Windows SBS premium edition , everything goes well but when I try to connect to the local database through Management studio it says connection failed & one of the possible reasons it says is SQL Browser service is not started.I tried to start the service but, when I go to services I could not find any such service in the list.There is only SQL server VSS writer service. Pls help me to come out of this situation. I tried reinstalling SQL server few times but in vain. Pls help me.
Thanks in advance.
Ramesh
Reporting Services :: Replacing Notification Services
Jan 4, 2013We are using Notification services of SQL Server 2005 in our application. The scenario is that mails will be sent to customers based on different criteria like New Invoices, Overdue Invoices, Invoices due in certain number of days, Invoices for which Amount Exceeds certain value etc. We are using two stored procedures and two tables to achieve this. One stored proc inserts/updates data related to different notifications that are selected by customers. Another stored proc inserts or updates data related to customers who created the notification.
We are now planning to upgrade from SQL 2005 to SQL server 2012. Since notification services are no longer supported in SQL 2012, we are looking for other alternatives. Which among the below would be the best alternative to replace notification services for our scenario. Also, anyny documentation or useful links which would support us in replacing notification services.
Reporting Services And Analysis Services
Aug 20, 2007
I have Reporting Services on one server and SQL and Analysis Services on another Server. I can develop a report using Analysis Services as the source from my local machine and it works fine. When I deploy it to the Reporting Services Server, it gives the following error:
An error has occurred during report processing.
Cannot create a connection to data source 'DataSource1'.
A connection cannot be made. Ensure that the server is running.
No connection could be made because the target machine actively refused it
Thank you in advnace for any help.
James
Sql Reporting Services And Analysis Services
Sep 26, 2007
Hello
I have been working on reporting services fetching data out of Sql Server. I want to know,if there are any sites than have information on working with MS.Services and Analysis Services together.
Analysis Services is something I have no knowledge about.
Thanks
Reporting Services With Analysis Services
May 30, 2006I have an important question and I've been roaming on MSDN and the internet to find a CLEAR answer. I'm really stuck here.
Is there a way to build a DYNAMIC Report with Visual Studio 2005 (SQL Server Business Intelligence Development Studio) and having a Cube (SQL Server 2005) as datasource?
I want a report that will act as the interface of the Cube browser in Analysis Services. I don't want to give access to the Cube Browser to users, but I want them to be able to drill-through the cube.
Thanks a lot.
Integration Services Notification Services
Apr 18, 2007Does anybody know of a notification services using SSIS? Is it SendMail or otherwise? Is there a step-by-step practice on how to create one?
View 19 Replies View RelatedMigrate From 32bit 2000 Reporting Services To 2005 64bit Reporting Services
Mar 22, 2008
Hello,
I am trying to migrate my reports from SQL server 2000 reporting services 32bit to 2005 64bit. I am following the migration steps that MS specified.
Restored my Reportserver and ReportserverTempDB databases
Then I was using the configure Report services to upgrade these databases but I always end up getting the follwoing exception when I run the upgrade on the "Database Setup" configuration for 'ReportServerTempDB' database
System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'ReportServerTempDBTempDB'. No entry found with that name. Make sure that the name is entered correctly.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)
It's driving me crazy, why is it looking for 'ReportServerTempDBTempDB' in the catalog instead of 'ReportServerTempDB'?
Is it possible to migrate from 32bit to 64bit?
Any help is appreciated
Compatibility Of SQL Express Reporting Services With SQL 2000 Reporting Services
Dec 6, 2006I'm attempting to obtain a cost effective solution for my existing customers to develop reports on their SQL 2000 Server installations using their Reporting Services 2000. With products like Visual Basic.NET 2003 becoming almost impossible to obtain, I have at least one customer who is running into a dead end.
One option possibly is the SQL Express with Advanced Services download, which has Reporting Services. My questions are as follows:
Can the report designer component of SQL Express Reporting Services be configured to connect to an external database (which would happen to be a SQL 2000 database) to establish its datasets?
Does the resultant designed report end up in an RDL file? If the customer published this report via the Reporting Services 2000 Report Manager, would the report be able to run?
Sorry for asking a question like this that I could probably answer on my own, but my customer needed this answer yesterday. I have scoured the web and microsoft sites - and posted a question on the official SQL Reporting Services cateogy ... in an attempt to answer the basic question of how to design reports for Reporting Services 2000 in the absence of Visual Basic.NET 2003 (or other .NET 2003 tools) with no success.
Thanks to anyone who can help.
-- Mark
Use Cubes From Analysis Services 2005 To Analysis Services 2000
Oct 17, 2007Hi,
I have some questions about SQL Servers 2000 and 2005 compatibility.
In my configuration I have to use both servers.
The cubes are stocked in 2005 server.
May I transfer from 2005 to 2000 Analysis Services the cubes?
If yes, what is the procedure? The result of migration is the same in the two different versions?
If not, how can I solve this problem?
Thanks in advance.