Error when passing GUID as Parameter

Hello - I am using SSRS 2005 and my report dataset has a parameter of type
GUID. In 2000 I could just pass this in as a string. I now get the error:
"Failed to convert parameter value from a String to a Guid."
I've tried setting my Dataset parameter value as:
=Guid(Parameters!<my parameter>.Value)
and
=New Guid(Parameters!<my parameter>.Value)
and I've tried passing in my string with and without the {} braces around
the GUID string.
Anyone have the anwser here? Thank you.I have confirmed that this appears to be a bug. However, there is a
work-around:
The report in the VS report preview or when deployed will work properly with
a uniqueidentifier parameter when the value is being passed in as string. In
order to execute the dataset in your report project, temporarily modify your
stored procedure to accept the guid as a string and convert it to a
uniqueidentifier in your proc. When you execute it and get your dataset
fields to design your report, you can change it back to a uniqueidentifier
parameter.
"justinsaraceno" wrote:
> Hello - I am using SSRS 2005 and my report dataset has a parameter of type
> GUID. In 2000 I could just pass this in as a string. I now get the error:
> "Failed to convert parameter value from a String to a Guid."
> I've tried setting my Dataset parameter value as:
> =Guid(Parameters!<my parameter>.Value)
> and
> =New Guid(Parameters!<my parameter>.Value)
> and I've tried passing in my string with and without the {} braces around
> the GUID string.
> Anyone have the anwser here? Thank you.

Error When Open Analysis Services From Management Studio

Dear All,

When I want to open Analysis

Services from Management Studio, an

error message appear:

Exception of type

'System.OutOfMemoryException' was thrown.

(Microsoft.SqlServer.SmoEnum)

Can anybody tell me what happen and how to solve that ?

Thanks in advance.

What version of Analysis Services you are running?

Try installing SP1. If that wouldnt help, try installing CTP of SP2.

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

|||Dear Edward,

Thanks for your reply. I have installed SP1 + Hotfix so the version of SSAS is 2153. Is it recommended to installed SP2 on Production server yet ? Thanks.|||

I wouldnt recommend installing CTP of SP2 without trying it first on the production machine.

But the problem looks like to be related to the SQL Management studio. Try installing CTP of SP2 on a client machine and then connecting to the server. See if the same error is happening.

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

|||Dear Edward,

FYI, I have 4 machine in my environment, one server (A) and the other three is client (B,C,D). I installed SP1 + hotfix on machine A, B, and C. I installed CTP of SP2 on D. A cannot open Analysis Services from management studio on its local, but can open Analysis Services on B and C. B and C can open Analysis Services on their local but cannot open the Analysis Services on A. D can open Analysis Services on its local and other machines (A, B, C). Is there any other solution besides installing CTP of SP2 on client ? Thanks.|||

In SP2 SQL Management studio is more efficient in opening big databases. Looks like that is the way to go.

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

|||Dear Edward,

Thanks for your information. Then I guess I have to wait for the release of SP2 to installed it on Production Server.

Error when create a Server object using SMO

Please help: I got this error and can't figure out what went wrong.

The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. on the line that create Server object.

This is the code (Visual C# 2005 - SQL Server 2000 - Windows Active Directory)

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

using Microsoft.SqlServer.Management.Smo;

using Microsoft.SqlServer.Management.Common;

namespace SSMO

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void Form1_Load(object sender, EventArgs e)

{

Server oSvr = new Server("myServer");

foreach (Database oDB in oSvr.Databases)

{

cboDatabases.Items.Add(oDB.Name.ToString());

}

}

}

I guess there should be additionally some inner exceptions which should clarify th error in detail.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

This is the error:

System.TypeInitializationException was unhandled
Message="The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception."
Source="System.Data"
TypeName="System.Data.SqlClient.SqlConnection"
StackTrace:
at System.Data.SqlClient.SqlConnection..ctor()
at Microsoft.SqlServer.Management.Common.ServerConnection..ctor()
at Microsoft.SqlServer.Management.Smo.ExecutionManager..ctor(String name)
at Microsoft.SqlServer.Management.Smo.Server..ctor(String name)
at SSMO.Form1.Form1_Load(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.SafeNativeMethods.ShowWindow(HandleRef hWnd, Int32 nCmdShow)
at System.Windows.Forms.Control.SetVisibleCore(Boolean value)
at System.Windows.Forms.Form.SetVisibleCore(Boolean value)
at System.Windows.Forms.Control.set_Visible(Boolean value)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at SSMO.Program.Main()
at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()

|||

As the constructor of the SQLConnection is throwing an error, this might be just a slight misconfiguration problem. As I searched through the Net I found that this could be something based on a misconigured app.config file or the lack of a bad installation where the performance counters of the SQL Connection classes are not fully installed and registered. Never had that, but try to use a more simple command to make sure that this is based on that error:

new
System.Data.SqlClient.SqlConnection()).Dispose();

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Error when cast Varchar to decimal

I'm writing a script with an insert statment to insert records from one
database to another but I have to change the type first. How can I find out
more about what can be causing this or is it something wrong with my syntax?
The field [patient_weight] is a varchar(256) stripped of all spaces left and
right.
Thanks, Alpha
cast([patient_weight] as decimal(10,2))
What result do you get here?
SELECT COUNT(*) FROM [source table name]
WHERE ISNUMERIC(patient_weight) = 0
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:D0914609-50C8-4480-A15D-302752BECA86@.microsoft.com...
> I'm writing a script with an insert statment to insert records from one
> database to another but I have to change the type first. How can I find
out
> more about what can be causing this or is it something wrong with my
syntax?
> The field [patient_weight] is a varchar(256) stripped of all spaces left
and
> right.
> Thanks, Alpha
> cast([patient_weight] as decimal(10,2))
>
|||I got 4. I looked at the table and they're all '0'(zero) except these 4.
"Aaron [SQL Server MVP]" wrote:

> What result do you get here?
> SELECT COUNT(*) FROM [source table name]
> WHERE ISNUMERIC(patient_weight) = 0
> --
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
>
>
> "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> news:D0914609-50C8-4480-A15D-302752BECA86@.microsoft.com...
> out
> syntax?
> and
>
>
|||Well, you need to fix those 4 rows.
SELECT * FROM Source_Table_Name
WHERE ISNUMERIC(patient_weight) = 0
If they look like 0's, maybe they're o's, or maybe they're zero's with
non-printable characters attached (e.g. carriage return).
UPDATE Source_Table_Name SET patient_weight = '0'
WHERE ISNUMERIC(patient_weight) = 0
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:5B264C8D-9F07-4A20-8066-93256AD0D975@.microsoft.com...[vbcol=seagreen]
> I got 4. I looked at the table and they're all '0'(zero) except these 4.
> "Aaron [SQL Server MVP]" wrote:
one[vbcol=seagreen]
find[vbcol=seagreen]
left[vbcol=seagreen]
|||Thank you that works but I don't understadn what happend here. So these 4
rows has a '0'(zero) char in it with CR. So how does this query able to
select it? ISNUMERIC cast it to 0 (zero in numerica) right? I don't
understand.
Thanks,
Alpha
> SELECT * FROM Source_Table_Name
> WHERE ISNUMERIC(patient_weight) = 0
"Aaron [SQL Server MVP]" wrote:

> Well, you need to fix those 4 rows.
> SELECT * FROM Source_Table_Name
> WHERE ISNUMERIC(patient_weight) = 0
> If they look like 0's, maybe they're o's, or maybe they're zero's with
> non-printable characters attached (e.g. carriage return).
> UPDATE Source_Table_Name SET patient_weight = '0'
> WHERE ISNUMERIC(patient_weight) = 0
> --
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
>
>
> "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> news:5B264C8D-9F07-4A20-8066-93256AD0D975@.microsoft.com...
> one
> find
> left
>
>
|||> Thank you that works but I don't understadn what happend here. So these 4
> rows has a '0'(zero) char in it with CR. So how does this query able to
> select it? ISNUMERIC cast it to 0 (zero in numerica) right?
No, ISNUMERIC(expression) returns either 1 or 0. If the number is numeric*,
it returns 1, otherwise it returns 0. Something about the way you decided
to store numeric data in a character data type led to problems in these 4
rows (which could have been predicted at the outset, and prevented by
choosing the correct data type).
* ISNUMERIC() is not perfect. See http://www.aspfaq.com/2390
|||Oh, got it. Thank you very much and have a nice day.
Alpha
"Aaron [SQL Server MVP]" wrote:

> No, ISNUMERIC(expression) returns either 1 or 0. If the number is numeric*,
> it returns 1, otherwise it returns 0. Something about the way you decided
> to store numeric data in a character data type led to problems in these 4
> rows (which could have been predicted at the outset, and prevented by
> choosing the correct data type).
> * ISNUMERIC() is not perfect. See http://www.aspfaq.com/2390
>
>

Error when cast Varchar to decimal

I'm writing a script with an insert statment to insert records from one
database to another but I have to change the type first. How can I find out
more about what can be causing this or is it something wrong with my syntax?
The field [patient_weight] is a varchar(256) stripped of all spaces left
and
right.
Thanks, Alpha
cast([patient_weight] as decimal(10,2))What result do you get here?
SELECT COUNT(*) FROM [source table name]
WHERE ISNUMERIC(patient_weight) = 0
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:D0914609-50C8-4480-A15D-302752BECA86@.microsoft.com...
> I'm writing a script with an insert statment to insert records from one
> database to another but I have to change the type first. How can I find
out
> more about what can be causing this or is it something wrong with my
syntax?
> The field [patient_weight] is a varchar(256) stripped of all spaces left[/vbco
l]
and[vbcol=seagreen]
> right.
> Thanks, Alpha
> cast([patient_weight] as decimal(10,2))
>|||I got 4. I looked at the table and they're all '0'(zero) except these 4.
"Aaron [SQL Server MVP]" wrote:

> What result do you get here?
> SELECT COUNT(*) FROM [source table name]
> WHERE ISNUMERIC(patient_weight) = 0
> --
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
>
>
> "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> news:D0914609-50C8-4480-A15D-302752BECA86@.microsoft.com...
> out
> syntax?
> and
>
>|||Well, you need to fix those 4 rows.
SELECT * FROM Source_Table_Name
WHERE ISNUMERIC(patient_weight) = 0
If they look like 0's, maybe they're o's, or maybe they're zero's with
non-printable characters attached (e.g. carriage return).
UPDATE Source_Table_Name SET patient_weight = '0'
WHERE ISNUMERIC(patient_weight) = 0
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:5B264C8D-9F07-4A20-8066-93256AD0D975@.microsoft.com...[vbcol=seagreen]
> I got 4. I looked at the table and they're all '0'(zero) except these 4.
> "Aaron [SQL Server MVP]" wrote:
>
one[vbcol=seagreen]
find[vbcol=seagreen]
left[vbcol=seagreen]|||Thank you that works but I don't understadn what happend here. So these 4
rows has a '0'(zero) char in it with CR. So how does this query able to
select it? ISNUMERIC cast it to 0 (zero in numerica) right? I don't
understand.
Thanks,
Alpha
> SELECT * FROM Source_Table_Name
> WHERE ISNUMERIC(patient_weight) = 0
"Aaron [SQL Server MVP]" wrote:

> Well, you need to fix those 4 rows.
> SELECT * FROM Source_Table_Name
> WHERE ISNUMERIC(patient_weight) = 0
> If they look like 0's, maybe they're o's, or maybe they're zero's with
> non-printable characters attached (e.g. carriage return).
> UPDATE Source_Table_Name SET patient_weight = '0'
> WHERE ISNUMERIC(patient_weight) = 0
> --
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
>
>
> "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> news:5B264C8D-9F07-4A20-8066-93256AD0D975@.microsoft.com...
> one
> find
> left
>
>|||> Thank you that works but I don't understadn what happend here. So these 4
> rows has a '0'(zero) char in it with CR. So how does this query able to
> select it? ISNUMERIC cast it to 0 (zero in numerica) right?
No, ISNUMERIC(expression) returns either 1 or 0. If the number is numeric*,
it returns 1, otherwise it returns 0. Something about the way you decided
to store numeric data in a character data type led to problems in these 4
rows (which could have been predicted at the outset, and prevented by
choosing the correct data type).
* ISNUMERIC() is not perfect. See http://www.aspfaq.com/2390|||Oh, got it. Thank you very much and have a nice day.
Alpha
"Aaron [SQL Server MVP]" wrote:

> No, ISNUMERIC(expression) returns either 1 or 0. If the number is numeric
*,
> it returns 1, otherwise it returns 0. Something about the way you decided
> to store numeric data in a character data type led to problems in these 4
> rows (which could have been predicted at the outset, and prevented by
> choosing the correct data type).
> * ISNUMERIC() is not perfect. See http://www.aspfaq.com/2390
>
>

Error when cast Varchar to decimal

I'm writing a script with an insert statment to insert records from one
database to another but I have to change the type first. How can I find out
more about what can be causing this or is it something wrong with my syntax?
The field [patient_weight] is a varchar(256) stripped of all spaces left and
right.
Thanks, Alpha
cast([patient_weight] as decimal(10,2))What result do you get here?
SELECT COUNT(*) FROM [source table name]
WHERE ISNUMERIC(patient_weight) = 0
--
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:D0914609-50C8-4480-A15D-302752BECA86@.microsoft.com...
> I'm writing a script with an insert statment to insert records from one
> database to another but I have to change the type first. How can I find
out
> more about what can be causing this or is it something wrong with my
syntax?
> The field [patient_weight] is a varchar(256) stripped of all spaces left
and
> right.
> Thanks, Alpha
> cast([patient_weight] as decimal(10,2))
>|||I got 4. I looked at the table and they're all '0'(zero) except these 4.
"Aaron [SQL Server MVP]" wrote:
> What result do you get here?
> SELECT COUNT(*) FROM [source table name]
> WHERE ISNUMERIC(patient_weight) = 0
> --
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
>
>
> "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> news:D0914609-50C8-4480-A15D-302752BECA86@.microsoft.com...
> > I'm writing a script with an insert statment to insert records from one
> > database to another but I have to change the type first. How can I find
> out
> > more about what can be causing this or is it something wrong with my
> syntax?
> > The field [patient_weight] is a varchar(256) stripped of all spaces left
> and
> > right.
> > Thanks, Alpha
> >
> > cast([patient_weight] as decimal(10,2))
> >
>
>|||Well, you need to fix those 4 rows.
SELECT * FROM Source_Table_Name
WHERE ISNUMERIC(patient_weight) = 0
If they look like 0's, maybe they're o's, or maybe they're zero's with
non-printable characters attached (e.g. carriage return).
UPDATE Source_Table_Name SET patient_weight = '0'
WHERE ISNUMERIC(patient_weight) = 0
--
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:5B264C8D-9F07-4A20-8066-93256AD0D975@.microsoft.com...
> I got 4. I looked at the table and they're all '0'(zero) except these 4.
> "Aaron [SQL Server MVP]" wrote:
> > What result do you get here?
> >
> > SELECT COUNT(*) FROM [source table name]
> > WHERE ISNUMERIC(patient_weight) = 0
> >
> > --
> > Please post DDL, sample data and desired results.
> > See http://www.aspfaq.com/5006 for info.
> >
> >
> >
> >
> > "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> > news:D0914609-50C8-4480-A15D-302752BECA86@.microsoft.com...
> > > I'm writing a script with an insert statment to insert records from
one
> > > database to another but I have to change the type first. How can I
find
> > out
> > > more about what can be causing this or is it something wrong with my
> > syntax?
> > > The field [patient_weight] is a varchar(256) stripped of all spaces
left
> > and
> > > right.
> > > Thanks, Alpha
> > >
> > > cast([patient_weight] as decimal(10,2))
> > >
> >
> >
> >|||Thank you that works but I don't understadn what happend here. So these 4
rows has a '0'(zero) char in it with CR. So how does this query able to
select it? ISNUMERIC cast it to 0 (zero in numerica) right? I don't
understand.
Thanks,
Alpha
> SELECT * FROM Source_Table_Name
> WHERE ISNUMERIC(patient_weight) = 0
"Aaron [SQL Server MVP]" wrote:
> Well, you need to fix those 4 rows.
> SELECT * FROM Source_Table_Name
> WHERE ISNUMERIC(patient_weight) = 0
> If they look like 0's, maybe they're o's, or maybe they're zero's with
> non-printable characters attached (e.g. carriage return).
> UPDATE Source_Table_Name SET patient_weight = '0'
> WHERE ISNUMERIC(patient_weight) = 0
> --
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
>
>
> "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> news:5B264C8D-9F07-4A20-8066-93256AD0D975@.microsoft.com...
> > I got 4. I looked at the table and they're all '0'(zero) except these 4.
> >
> > "Aaron [SQL Server MVP]" wrote:
> >
> > > What result do you get here?
> > >
> > > SELECT COUNT(*) FROM [source table name]
> > > WHERE ISNUMERIC(patient_weight) = 0
> > >
> > > --
> > > Please post DDL, sample data and desired results.
> > > See http://www.aspfaq.com/5006 for info.
> > >
> > >
> > >
> > >
> > > "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> > > news:D0914609-50C8-4480-A15D-302752BECA86@.microsoft.com...
> > > > I'm writing a script with an insert statment to insert records from
> one
> > > > database to another but I have to change the type first. How can I
> find
> > > out
> > > > more about what can be causing this or is it something wrong with my
> > > syntax?
> > > > The field [patient_weight] is a varchar(256) stripped of all spaces
> left
> > > and
> > > > right.
> > > > Thanks, Alpha
> > > >
> > > > cast([patient_weight] as decimal(10,2))
> > > >
> > >
> > >
> > >
>
>|||> Thank you that works but I don't understadn what happend here. So these 4
> rows has a '0'(zero) char in it with CR. So how does this query able to
> select it? ISNUMERIC cast it to 0 (zero in numerica) right?
No, ISNUMERIC(expression) returns either 1 or 0. If the number is numeric*,
it returns 1, otherwise it returns 0. Something about the way you decided
to store numeric data in a character data type led to problems in these 4
rows (which could have been predicted at the outset, and prevented by
choosing the correct data type).
* ISNUMERIC() is not perfect. See http://www.aspfaq.com/2390|||Oh, got it. Thank you very much and have a nice day.
Alpha
"Aaron [SQL Server MVP]" wrote:
> > Thank you that works but I don't understadn what happend here. So these 4
> > rows has a '0'(zero) char in it with CR. So how does this query able to
> > select it? ISNUMERIC cast it to 0 (zero in numerica) right?
> No, ISNUMERIC(expression) returns either 1 or 0. If the number is numeric*,
> it returns 1, otherwise it returns 0. Something about the way you decided
> to store numeric data in a character data type led to problems in these 4
> rows (which could have been predicted at the outset, and prevented by
> choosing the correct data type).
> * ISNUMERIC() is not perfect. See http://www.aspfaq.com/2390
>
>

Error when attempting to render HTML report from report server.

When I attempt to render a deployed report as HTML (any version) I get the
following error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Item has already been added. Key in dictionary: "32" Key being added: "32"
This error does not occur when rendering the report in any other format
(PDF, Excel, XML etc.). The report also works fine in all preview modes
with VS.Net 2003.
Variants of this problem have been reported 4 times previously in this news
group (3 times with reference to the Excel Rendering and once with reference
to HTML rendering) but there's been no response as to how (or if) it can be
resolved.
The only KB article I can find with potentially any relevance is:
http://support.microsoft.com/default.aspx?scid=kb;en-us;870722
It contains details of a hotfix but as my circumstances are different, I
have no idea if it's really relevant.
TIA
Danny
If it helps, my stack trace is:
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
A_0, GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
ProcessingContext pc, RenderingContext rc)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
reportContext, ItemProperties properties, ParameterInfoCollection
effectiveParameters, Guid reportId, ClientRequest session, String
description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
thisReportDataSources, Boolean cachingRequested, Warning[]& warnings,
ReportSnapshot& resultSnapshotData, DateTime& executionDateTime,
RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
usedUserProfile)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()If you have a detailed repro, I can take a look at it. Send mail directly
to me bradsy@.microsoft.com
--
| From: "Danny Shisler" <dannyshisler@.techhelpplease.com>
| Subject: Error when attempting to render HTML report from report server.
| Date: Mon, 25 Oct 2004 15:59:23 +0100
| Lines: 60
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| Message-ID: <OCzXJNquEHA.960@.TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 213.228.233.162
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10

Error Type 'System.Xml.XmlTextWriter' is not defined

I use this Code in SSIS Destination Script Transforamtion:
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper
Imports System.Xml

Public Class ScriptMain
Inherits UserComponent
Dim xWriter As XmlTextWriter
' get this Error: Type 'System.Xml.XmlTextWriter' is not defined

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
End Sub
End Class

Whats wrong ?

I use CTP Sept 2005 on Windows XP German.

Willfried

You need to add a reference to System.Xml in your script component

Go to Project|Add Reference... and select System.xml from the assembly list|||Thanks, i'm a fool |||Don't worry I just spent 30 minutes doing exactly the same thing

error trying to move data from 1 table to another.

Hi I am getting the following error
Syntax error converting the nvarchar value 'null' to a column of data type int
while attempting to move data from 1 table to another with the script,
INSERT INTO [dbase1].dbo.DML$table1
([Data_Item_ID])
SELECT CAST([Data_Item_ID]as int)
from [DML1].dbo.dataitemlog
I have allow not NULL for both source and destination fields, so do not see
how I could be getting this error, also did not see any null values in the
source field. The source data type is
(nvarchar (4) not null)
and the destination field data type is (int, not null)
any suggestions? thanks.
--
Paul G
Software engineer.this problem has been addressed in a previous post. thanks, Paul.
"Paul" wrote:
> Hi I am getting the following error
> Syntax error converting the nvarchar value 'null' to a column of data type int
> while attempting to move data from 1 table to another with the script,
> INSERT INTO [dbase1].dbo.DML$table1
> ([Data_Item_ID])
> SELECT CAST([Data_Item_ID]as int)
> from [DML1].dbo.dataitemlog
> I have allow not NULL for both source and destination fields, so do not see
> how I could be getting this error, also did not see any null values in the
> source field. The source data type is
> (nvarchar (4) not null)
> and the destination field data type is (int, not null)
> any suggestions? thanks.
> --
> Paul G
> Software engineer.

error trying to move data from 1 table to another.

Hi I am getting the following error
Syntax error converting the nvarchar value 'null' to a column of data type i
nt
while attempting to move data from 1 table to another with the script,
INSERT INTO [dbase1].dbo.DML$table1
([Data_Item_ID])
SELECT CAST([Data_Item_ID]as int)
from [DML1].dbo.dataitemlog
I have allow not NULL for both source and destination fields, so do not see
how I could be getting this error, also did not see any null values in the
source field. The source data type is
(nvarchar (4) not null)
and the destination field data type is (int, not null)
any suggestions? thanks.
--
Paul G
Software engineer.this problem has been addressed in a previous post. thanks, Paul.
"Paul" wrote:

> Hi I am getting the following error
> Syntax error converting the nvarchar value 'null' to a column of data type
int
> while attempting to move data from 1 table to another with the script,
> INSERT INTO [dbase1].dbo.DML$table1
> ([Data_Item_ID])
> SELECT CAST([Data_Item_ID]as int)
> from [DML1].dbo.dataitemlog
> I have allow not NULL for both source and destination fields, so do not se
e
> how I could be getting this error, also did not see any null values in the
> source field. The source data type is
> (nvarchar (4) not null)
> and the destination field data type is (int, not null)
> any suggestions? thanks.
> --
> Paul G
> Software engineer.

error trying to move data from 1 table to another.

Hi I am getting the following error
Syntax error converting the nvarchar value 'null' to a column of data type int
while attempting to move data from 1 table to another with the script,
INSERT INTO [dbase1].dbo.DML$table1
([Data_Item_ID])
SELECT CAST([Data_Item_ID]as int)
from [DML1].dbo.dataitemlog
I have allow not NULL for both source and destination fields, so do not see
how I could be getting this error, also did not see any null values in the
source field. The source data type is
(nvarchar (4) not null)
and the destination field data type is (int, not null)
any suggestions? thanks.
Paul G
Software engineer.
this problem has been addressed in a previous post. thanks, Paul.
"Paul" wrote:

> Hi I am getting the following error
> Syntax error converting the nvarchar value 'null' to a column of data type int
> while attempting to move data from 1 table to another with the script,
> INSERT INTO [dbase1].dbo.DML$table1
> ([Data_Item_ID])
> SELECT CAST([Data_Item_ID]as int)
> from [DML1].dbo.dataitemlog
> I have allow not NULL for both source and destination fields, so do not see
> how I could be getting this error, also did not see any null values in the
> source field. The source data type is
> (nvarchar (4) not null)
> and the destination field data type is (int, not null)
> any suggestions? thanks.
> --
> Paul G
> Software engineer.

Error S1003 ... Program Type Out Of Range

I am receiving an "S1003 ... Program Type Out Of Range" error when retrievin
g data but cannot find any additional documented help on it's meaning nor a
solution to the problem.
Any and all help is greatly appreciated.
Thanks,
Jim.This doesn't look like a SQL Server error. I suggest you ask the vendor of t
he application what this
means.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"JimJNH" <anonymous@.discussions.microsoft.com> wrote in message
news:722C411A-6C52-439B-87C8-8F697A2BA05B@.microsoft.com...

quote:

---

> I am receiving an "S1003 ... Program Type Out Of Range" error when retrieving data but can
not find

---

any additional documented help on it's meaning nor a solution to the problem.

quote:

---

> Any and all help is greatly appreciated.
> Thanks,
> Jim.

---

|||The ODBC Error comes up exactly as follows:
Select Error: SQLSTATE = S1003
[Microsoft][ODBC Driver Manager] Program Type Out of range
The Select works fine with other ODBC drivers (Sybase, Oracle, ...) but fail
s with SQL Server.
-- Tibor Karaszi wrote: --
This doesn't look like a SQL Server error. I suggest you ask the vendor of t
he application what this
means.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"JimJNH" <anonymous@.discussions.microsoft.com> wrote in message
news:722C411A-6C52-439B-87C8-8F697A2BA05B@.microsoft.com...

quote:

---

> I am receiving an "S1003 ... Program Type Out Of Range" error when retrieving data but can
not find

---

any additional documented help on it's meaning nor a solution to the problem.[QUOTE][color=darkred
]

Error S1003 ... Program Type Out Of Range

I am receiving an "S1003 ... Program Type Out Of Range" error when retrieving data but cannot find any additional documented help on it's meaning nor a solution to the problem.
Any and all help is greatly appreciated.
Thanks,
Jim.This doesn't look like a SQL Server error. I suggest you ask the vendor of the application what this
means.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"JimJNH" <anonymous@.discussions.microsoft.com> wrote in message
news:722C411A-6C52-439B-87C8-8F697A2BA05B@.microsoft.com...
> I am receiving an "S1003 ... Program Type Out Of Range" error when retrieving data but cannot find
any additional documented help on it's meaning nor a solution to the problem.
> Any and all help is greatly appreciated.
> Thanks,
> Jim.|||The ODBC Error comes up exactly as follows:
Select Error: SQLSTATE = S1003
[Microsoft][ODBC Driver Manager] Program Type Out of range
The Select works fine with other ODBC drivers (Sybase, Oracle, ...) but fails with SQL Server.
-- Tibor Karaszi wrote: --
This doesn't look like a SQL Server error. I suggest you ask the vendor of the application what this
means.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"JimJNH" <anonymous@.discussions.microsoft.com> wrote in message
news:722C411A-6C52-439B-87C8-8F697A2BA05B@.microsoft.com...
> I am receiving an "S1003 ... Program Type Out Of Range" error when retrieving data but cannot find
any additional documented help on it's meaning nor a solution to the problem.
>> Any and all help is greatly appreciated.
>> Thanks,
>> Jim.