How do I monitor MSDE performance

Hi there,
How can I monitor the MSDE performance. I read about it
on the MSDN site but was not clear what tool to use.
Can u help?
Thanks,
FP
hi FP,
FP wrote:
> Hi there,
> How can I monitor the MSDE performance. I read about it
> on the MSDN site but was not clear what tool to use.
> Can u help?
depending on what you want to monitor, you can even use the System Monitor,
adding your preferred counters, like
http://www.windowsitpro.com/Articles...layTab=Article
http://www.windowsitpro.com/Articles...layTab=Article
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

How do i implement If Then Else Conditions

Hi All,

I'm very new to Integration Services. Self Learned this ETL tool based on my prior ETL tool knowledge.

Can you tell me how do write IF Then Else conditions for every column in my source and redirect to a single output?

Hey correction here ... i'm using flat file as my source

Thanks in Advance,

Suresh N

It would help if you could provide a more explicit example of the type of logic you're hoping to implement, but here is a response based on my best guess at what you're trying to accomplish.

FIrst, start with the Derived Column transformation in your data flow: http://msdn2.microsoft.com/en-us/library/ms141069.aspx. This transform is the tool of choice for adding new columns - including new columns based on conditional logic and the values in existing columns - to your data flow.

Next, build an expression using the SSIS conditional operator to implement the If Then Else logic you need: http://msdn2.microsoft.com/en-us/library/ms141680.aspx.

You can also use the Script Transformation to perform more complex If Then Else logic in the data flow, but I personally try to avoid this if I can, as it makes your packages more difficult to maintain.

Please let us know if this gives you what you need.

|||

Thanks for reply Matthew.

I'm not able to do. Still needed help.

I have a flat file as a source, for each column i need to detect for NULL values. If it is NULL then i need to populate "99" Else Value.

I'm trying the same in Derived column transformation, not succeeded.

Do SSIS have something where i could write If Then Else ?

thanks..

Suresh N

|||

Suresh,

You can use a derived column transformation in the data flow with an conditional expression like

ISNULL(column1) ? 99 : column1

http://msdn2.microsoft.com/en-us/library/ms137538.aspx

|||

Suresh N wrote:

Thanks for reply Matthew.

I'm not able to do. Still needed help.

I have a flat file as a source, for each column i need to detect for NULL values. If it is NULL then i need to populate "99" Else Value.

I'm trying the same in Derived column transformation, not succeeded.

Do SSIS have something where i could write If Then Else ?

thanks..

Suresh N

This is exactly what the Derived Column transform is designed to do. Can you please post some specific information about what you are doing and what results you're seeing. There's not a lot of helpful information in your post to assist in troubleshooting.

|||

Hi Rafael,

Thanks much for your answer.

This has made my job done.

Regards,

Suresh N

|||

If you have to do this for several files accross a couple of packages then this when I think you should consider a custom transform. Faster development and maintenance as well as the ability to control custom business rules in a single (external to packages) assembly. The use of 99 in a local business rule I believe.

How Do I Hide Internet Explorer Menu and Tool Bar

How can I hide the Internet Explorer Menu and Tool Bar in SQL Reporting.

If I am understanding what you are asking, that is not possible with SSRS.

|||I have a report generated by SQL Reporting service from another program, I just want the Internet Explorer Menu and tool to be hidden so that the user could not navigate to another site.|||Hi -

You should be able to do this using javascript in the calling page. Something like:

function popReport(parm)
{

window.open("path\to\report?parameters="+parm, "WindowName", "location=no, scrollbars=yes, menubar=no, status=no, resizable=yes, height=500px, width=300px");

}

You can call it using the onclick event of an item in the calling page, like:

<a onclick="return popReport('<% =label.Text %> ')" href="#">....</a>

Here's a link to some more information
http://msdn2.microsoft.com/en-us/library/ms536651.aspx

HTH...

Joe|||

I tried that , but it did not work since the SQL Reporting Service launches the Internet Explorer.

Is there a way to configure the the Report to pass parameters to IE ?

|||I'm not following you. Are browsing to the reports from within Report Manager? Or are you calling the report from another web page?

Joe|||I am calling the report from another web page passing the report parameters. The problem is after the report is launched . I do not want the user to have access to the Internet Explorer Menu or any Web navigational tool, want the IE to display the report and the report tools but not the IE Menu and Tools or the Address Bar.|||

Then you would probably want to handle this with the web page. SSRS generates reports. It really has nothing to do with Internet Explorer other than it is displayed IN Internet Explorer.

Are you using Visual Studio 2005 to create a web application? If so, you will have quite a bit of control over the web page. What tool are you using? Or are you creating the web page from "scratch"?

How Do I Hide Internet Explorer Menu and Tool Bar

How can I hide the Internet Explorer Menu and Tool Bar in SQL Reporting.

If I am understanding what you are asking, that is not possible with SSRS.

|||I have a report generated by SQL Reporting service from another program, I just want the Internet Explorer Menu and tool to be hidden so that the user could not navigate to another site.|||Hi -

You should be able to do this using javascript in the calling page. Something like:

function popReport(parm)
{

window.open("path\to\report?parameters="+parm, "WindowName", "location=no, scrollbars=yes, menubar=no, status=no, resizable=yes, height=500px, width=300px");

}

You can call it using the onclick event of an item in the calling page, like:

<a onclick="return popReport('<% =label.Text %> ')" href="#">....</a>

Here's a link to some more information
http://msdn2.microsoft.com/en-us/library/ms536651.aspx

HTH...

Joe|||

I tried that , but it did not work since the SQL Reporting Service launches the Internet Explorer.

Is there a way to configure the the Report to pass parameters to IE ?

|||I'm not following you. Are browsing to the reports from within Report Manager? Or are you calling the report from another web page?

Joe|||I am calling the report from another web page passing the report parameters. The problem is after the report is launched . I do not want the user to have access to the Internet Explorer Menu or any Web navigational tool, want the IE to display the report and the report tools but not the IE Menu and Tools or the Address Bar.|||

Then you would probably want to handle this with the web page. SSRS generates reports. It really has nothing to do with Internet Explorer other than it is displayed IN Internet Explorer.

Are you using Visual Studio 2005 to create a web application? If so, you will have quite a bit of control over the web page. What tool are you using? Or are you creating the web page from "scratch"?

sql

How Do I Hide Internet Explorer Menu and Tool Bar

How can I hide the Internet Explorer Menu and Tool Bar in SQL Reporting.

If I am understanding what you are asking, that is not possible with SSRS.

|||I have a report generated by SQL Reporting service from another program, I just want the Internet Explorer Menu and tool to be hidden so that the user could not navigate to another site.|||Hi -

You should be able to do this using javascript in the calling page. Something like:

function popReport(parm)
{

window.open("path\to\report?parameters="+parm, "WindowName", "location=no, scrollbars=yes, menubar=no, status=no, resizable=yes, height=500px, width=300px");

}

You can call it using the onclick event of an item in the calling page, like:

<a onclick="return popReport('<% =label.Text %> ')" href="#">....</a>

Here's a link to some more information
http://msdn2.microsoft.com/en-us/library/ms536651.aspx

HTH...

Joe|||

I tried that , but it did not work since the SQL Reporting Service launches the Internet Explorer.

Is there a way to configure the the Report to pass parameters to IE ?

|||I'm not following you. Are browsing to the reports from within Report Manager? Or are you calling the report from another web page?

Joe|||I am calling the report from another web page passing the report parameters. The problem is after the report is launched . I do not want the user to have access to the Internet Explorer Menu or any Web navigational tool, want the IE to display the report and the report tools but not the IE Menu and Tools or the Address Bar.|||

Then you would probably want to handle this with the web page. SSRS generates reports. It really has nothing to do with Internet Explorer other than it is displayed IN Internet Explorer.

Are you using Visual Studio 2005 to create a web application? If so, you will have quite a bit of control over the web page. What tool are you using? Or are you creating the web page from "scratch"?

How do I get the Table Name the column belongs to in SMO?

Hi guys,

I am writing some sort of tool and I need to get the table a column belongs to.Before you ask for certain reasons too long to explain I need to get it from the column.

I have found out that the following will give me the answer however before I start splitting the string which it could be messy.

is there another way to do it?

My way so far:

?col.Urn.Value Gives:
"Server[@.Name='MYServer']/Database[@.Name='MyDB]/Table[@.Name='UserTable' and @.Schema='dbo']/Column[@.Name='Surname']"

So now .How can I split it to get the table Name? or better is there a cleaner way to do it?

Thanks again for your time in advance

col.Parent will return you a SqlSmoObject which you can cast as a Table (or View).

Hope that helps.

Thanks,
Kuntal

|||That helped and worked thanks.

HOW Do I GET DATA ANALYZER TO CONNECT TO MY SSAS 2005 DB's EXTERNALLY?

okay,

I have the SSAS 2005 cubes migrated. I have loaded MS Data Analyzer (the client ad-hoc quesry tool of choice for the CXX's and SSAS 2005) and can connect with no problem LOCALLY on the DA- installed on local machine. I have no lucky externally. I keep getting the error: Cannot connect to the "MYDBSERVER". The server is either not started ot too busy. HELP!!

kj

There coupld be multiple things going on.

1. You are missing new AS 9 OLEDB provider. Download and install Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider from http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

2. Your firewall might be blocking AS TCP port. Open port 2383 for default instance of AS.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.