Cannot pass params (data type system.guid) to subreport?

Hello experts,

I am trying to create a report including a subreport in VS.2003 Reporting services. The subreport itself runs properly, if I give it a parameter, but when I try to run the main (parent) report, I get the obvious message Subreport could not be shown.

The output windows returns a message:

The value expression used in textbox ‘AccountID’ returned a data type that is not valid.

The AccountID field is a system.guid. I tried to "cast" it as a text, but I got another error message that the system.guid cannot be explicitly converted.

Does anyone know how to get around this?

Thank you very much.

Ravie.

The .NET GUID structure has ToString() method to get the guid converted to string. On the other side, you can use the GUID(string) constructor to convert it back to guid.sql

Cannot map tinyint to a SSIS data type in resultset

If I have an executesql task that returns a result set, if the result set contains a tinyint, I can't find what SSIS data type to declare the variable as. They all cause errors.

Answered my own question have a look at my post

http://www.sqljunkies.com/WebLog/simons/archive/2006/02/24/tinyint_in_SSIS.aspx

Cannot map tinyint to a SSIS data type in resultset

If I have an executesql task that returns a result set, if the result set contains a tinyint, I can't find what SSIS data type to declare the variable as. They all cause errors.

Answered my own question have a look at my post

http://www.sqljunkies.com/WebLog/simons/archive/2006/02/24/tinyint_in_SSIS.aspx

Cannot Login with Web Data Administrator

With Cassini web server, the hour glass stays on after I type in "sa" and password with SQL Login. Does anyone know how to resolve the issue?

With IIS, it simply displays the content of default.aspx as text. Are there some settings need to be changed?

My system is: Windows XP Professional with SP2.

Any help is appreciated.

Chinghuh? let's be more descriptive.|||Kay,

After I installed the SQL Web Data Administrator on my computer, I started it with IIS selected. It comes back displaying the content of http://localhost/webadmin/default.aspx in IE.

I then change the selection to Cassini Personal Web Server and start. The desired port is changed to 111. The logon page displays in IE. I type in "sa" in Username field and myPassword in Password field. The server field is (local) and the Authentication Method is "SQL Login". After I click the Login button, the hour glass stays.

Do you know how to solve this problem? Thank you for any help.

Ching|||Is your database installed and running? Unfortunately, I don't use Cassini, so I don't know what's wrong.

Cannot kill process with EC wait type

Hi
I had tired to create index on large databse (>200GB, engine ss2k) but
I got errors, so I executed DBCC CHECKDB. DBCC told me that I have to
execute it with repair options. But I noticed in Activity Monitor that
I had still running creating index process with EC wait type. Then I
started to kill it but without success.
Is it possible to kill such process, without restarting sql server?
Best regards,
BartekHi Bartek
The process may be rolling back try KILL WITH STATUSONLY to see what it is
doing.
John
"Bartolo" wrote:
> Hi
> I had tired to create index on large databse (>200GB, engine ss2k) but
> I got errors, so I executed DBCC CHECKDB. DBCC told me that I have to
> execute it with repair options. But I noticed in Activity Monitor that
> I had still running creating index process with EC wait type. Then I
> started to kill it but without success.
> Is it possible to kill such process, without restarting sql server?
> Best regards,
> Bartek
>|||Hi John
Thanks for reponse. I tried this one, it stuck to 100% for few days.
I got reply on another forums that I can't even kill this process with
server restart.
It is really confusing that there is no way to get rid off such
process.
Bartek
On 16 Mar, 08:22, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Bartek
> The process may be rolling back try KILL WITH STATUSONLY to see what it is
> doing.
> John
> "Bartolo" wrote:
> > Hi
> > I had tired to create index on large databse (>200GB, engine ss2k) but
> > I got errors, so I executed DBCC CHECKDB. DBCC told me that I have to
> > execute it with repair options. But I noticed in Activity Monitor that
> > I had still running creating index process with EC wait type. Then I
> > started to kill it but without success.
> > Is it possible to kill such process, without restarting sql server?
> > Best regards,
> > Bartek|||I succeeded.
It seems that restarting SQL Server is the only opition to get rid of
such process.
Cheers,
Bartek
On 17 Mar, 12:51, Bartolo <andrew...@.gmail.com> wrote:
> Hi John
> Thanks for reponse. I tried this one, it stuck to 100% for few days.
> I got reply on another forums that I can't even kill this process with
> server restart.
> It is really confusing that there is no way to get rid off such
> process.
> Bartek
> On 16 Mar, 08:22, John Bell <jbellnewspo...@.hotmail.com> wrote:
> > Hi Bartek
> > The process may be rolling back try KILL WITH STATUSONLY to see what it is
> > doing.
> > John
> > "Bartolo" wrote:
> > > Hi
> > > I had tired to create index on large databse (>200GB, engine ss2k) but
> > > I got errors, so I executed DBCC CHECKDB. DBCC told me that I have to
> > > execute it with repair options. But I noticed in Activity Monitor that
> > > I had still running creating index process with EC wait type. Then I
> > > started to kill it but without success.
> > > Is it possible to kill such process, without restarting sql server?
> > > Best regards,
> > > Bartek

Cannot import Oracle data with OLE DB

I have a column in an Oracle source system with data type NUMBER(38,2). The value "-0.01" is causing problems when trying to import into a SSIS data-flow.

The only way I can import this into my data-flow is by using a Datareader connection manager using the ODBC Data Provider. My DSN is using the Oracle ODBC driver.

If I try and use the "Native OLE DB\Microsoft OLE DB Provider for Oracle" I get an error: "The data value cannot be converted for reasons other than sign mismatch or data overflow"

Judging by this post: http://microsoftdw.blogspot.com/2005/11/final-storyhow-to-get-data-out-of.html there aren't really any other combinations to try that will bring my data in as I want it.

I don't want to use ODBC though as:

Its an old technology Its slow I have to deploy an additional DSN.

Can anyone tell me why the other options don't work? Why does Microsoft OLE DB Provider for Oracle have a problem with "-0.01"?

-Jamie

When I tried to reproduce the issue reported by you, I encountered different set of problems. I tried to copy data from a Oracle table with NUMBER(38,2) column to a SQL Server 2005 table with a NUMERIC (38,2) column using OraOLEDB (and later using MSDORA) OLE DB connection manager at the source. I dont get any error messages when I execute the package. However, no data is transferred and I do not see any data when I preview the data at the source. May be I am missing something that you did that produced the error message you got.|||

Well I can't even preview the data so I think my problem is more deep seated. My errors occur in the source adapter and hence I think I have a problem in the middleware.

-Jamie