Showing posts with label guys. Show all posts
Showing posts with label guys. Show all posts

Tuesday, March 27, 2012

Can't change name of report

Good Morning Guys,

Can anybody tell me how to change the name Property of a report on the Report Server?

When im using the standard Webpage, i can change all the properties i want.

But when i try the same in code. Changing the name property gets me a read-only exception.
The description does change but i actually want the name to change.

public string setProperties(string property,string value, string itemPath)
{
try
{
Property[] props = new Property[1];
Property setProp = new Property();
setProp.Name = property;
setProp.Value = value;
props[0] = setProp;
rpServer.SetProperties(itemPath, props);
}
catch (SoapException ex)
{
throw ex;
}
return "";
}


Is there an easy way around this, or do i have to solve it by creating a new report with a new name, and delete the old one?

Thanks in advance,

You need to call the MoveItem API.|||Tnx Teo,
I still think its strange to have a function to set properties.
And you cant set the most important property :)
Greetings
PS: the blond girl name was to draw attention, cause this issue was quite high prio. ;) Sorry for that.|||

The name isn’t really a property in that it changes the path in the namespace. For example, you can’t have two things with the same path, etc.

PS: How disappointing :-)

Monday, March 19, 2012

Cannot work with Scrip task

Hey guys,
It's sort of madness I guess. :))
I use Script Task.
It has no code inside, but "Dts.TaskResult = Dts.Results.Success"
I execute package. I'm getting error

Error: 0x5 at Script Task: The script files failed to load.

Task failed: Script Task
What is it? How I can fix it? What's wrong?
Thanks.

Check out this thread ...

http://forums.microsoft.com/msdn/showpost.aspx?postid=68546&siteid=1

Donald

|||Thanks. It works.

Wednesday, March 7, 2012

Cannot start Sql service

Hi guys,
I had 2 SQL Servers on my machine, one was the MSDE netSDK
and the other was MS SQL Server 2000.
I removed the latter as I was quite happy with MSDE but
as soon as I removed it the play icon in the SQL Manager
disappeared and I get a message saying
'Cannot find the file specified' as there is nothing in
the services drop down combo. How do I fix this. I still
have all my databases in the netSDK.
Thanks in advance
Regards
tribalIfI remember correctly removing the SQL Server instance removes all of the
GUI tools. You'll need to find a free GUI for the MSDE since the once that
came with SQL Server are gone.
"tribal" <tribal@.mail.com> wrote in message
news:04a601c368ab$0d62f030$a001280a@.phx.gbl...
> Hi guys,
> I had 2 SQL Servers on my machine, one was the MSDE netSDK
> and the other was MS SQL Server 2000.
> I removed the latter as I was quite happy with MSDE but
> as soon as I removed it the play icon in the SQL Manager
> disappeared and I get a message saying
> 'Cannot find the file specified' as there is nothing in
> the services drop down combo. How do I fix this. I still
> have all my databases in the netSDK.
> Thanks in advance
> Regards
> tribal

Friday, February 10, 2012

cannot restore a backup database

hi all,

i just learned mssql server and need help form u guys the experts. i made a backup of database but i couldnt restore it into another machine.
the original database name is "employee" and running in mssql 7. the target database is named "employee" as well and running in mssql 2000.
it gave me this message:

Microsoft SQL-DMO (ODBC SQLState: 42000)

Cannot find file ID 2 on the device 'C:\db_bak\employee.dat'.
RESTORE DATABASE is terminating abnormally.

i tried to restore it to another mssql 7 but it gave me the same error message. i dont know how to fix it. in the sql server log, nothing refers to the restore activity. please help...

thanx in advance,

tonjawin mssql2000 i faced a similar problem.

but the problem was solved when i gave the correct path name for the data and log file.(installation directory\data path)