Viewing 15 posts - 46 through 60 (of 69 total)
You can process a cube directly from the SQL Server Agent. Add a step of type "SQL Server Analysis Services Command" and enter a XMLA Query to process the cube....
June 18, 2008 at 6:21 am
Ah thanx, that was pretty easy, just added a group with a group header with no text. 🙂
June 17, 2008 at 8:28 am
MS Excel is an option, connect to an SSAS cube from Excel and then you have the slice & dice view much like Pivot tables. Another option could be to...
June 17, 2008 at 2:51 am
You can process a cube directly from the SQL Server Agent without the use of SSIS.
Add a step of type "SQL Server Analysis Services Command" and enter a XMLA...
June 16, 2008 at 3:42 am
Hi
Have you tried setting the NOCOUNT to ON in the beginning of your SP?
This could prevent extra result sets from interfering with SELECT statements
SET NOCOUNT ON
June 16, 2008 at 3:23 am
Hi
I had the same problem on a project last year, also had to connect to an Oracle DB from SSIS but kept getting the same error, struggled with this one!...
June 13, 2008 at 4:14 am
Check if the SQL Server Reporting Services service is started from Services under Administrator Tools.
June 13, 2008 at 3:28 am
Sorry that wasnt enough info.
Install those to files on your SQL server, attach the databases.
Also download SqlServerSamples.msi from the following address:
http://www.codeplex.com/SqlServerSamples/Release/ProjectReleases.aspx?ReleaseId=4000
Install and find sample of SSIS, SSRS and...
June 13, 2008 at 3:23 am
From this page download:
AdventureWorksDB.msi - OLTP database
AdventureWorksBI.msi - OLAP Database
http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004
June 13, 2008 at 3:09 am
Do you want to host the reports on your local machine you are working on?
Other thing, is your Reporting Server service started, can you connect to it from SSMS?
June 13, 2008 at 3:00 am
Right click your report project from the Solution Explorer in BIDS and select properties.
Enter the name of the target server where you want to deploy your reports to in the...
June 12, 2008 at 5:51 am
It should be exactly the same as executing a select statement from an Execute SQL Task. Set the ResultSet = Full Result Set and in the Result Set tab set...
June 11, 2008 at 8:12 am
Who needs books & training courses when we have SQL Server Central! Hehe 🙂
June 11, 2008 at 2:53 am
The code below will also work, change the ORDER BY according to the column that you want the second row from, I assumed it was the Sal column.
WITH Empl AS
(
SELECT...
June 10, 2008 at 5:28 am
Viewing 15 posts - 46 through 60 (of 69 total)