Problem with Look up

Hi all;

I have created a SSIS package to import data from flat file to database table, which consists of
Flat file Source -> Look up -> OLE DB Destination.
I'm using Look Up in order to avoid duplicate records.
My database table contain around 35,00000 s of rows.
So when I'm running the package the above amount of data goes to Lookup cache, which require a large storage memory.
So I'm not able to execute my package.
I need to run the package in order to update my database.
So is there any solution, in which I can check the duplicate records to get into the database and time consumption to run the package will be less.

Thanks in advance...

Be sure that you are using a SQL statement to only select distinct keys from the table:

select primary_key from table

Then you just simply join the key fields.|||

Hi Sanidha,

You may want to consider key staging the lookup table. Prior to performing the lookup against a 35 million row table, create a staging table containing only the columns (and rows, if identifiable) needed to perform the lookup, then use it instead of the full table.

Hope this helps,
Andy

|||

Andy Leonard wrote:

Hi Sanidha,

You may want to consider key staging the lookup table. Prior to performing the lookup against a 35 million row table, create a staging table containing only the columns (and rows, if identifiable) needed to perform the lookup, then use it instead of the full table.

Hope this helps,
Andy

Why would this matter? Selecting the primary key of the full table (should be indexed!) should be less work than staging the keys first, and then selecting from there. That sounds like an extra, unnecessary step to me and will, in turn, cost more than my approach.

Am I missing something? Unless of course, you're talking about performing a SQL join against that staging table so as to avoid caching the keys in memory.|||

My apologies Sanidha,

I thought the lookup table contained too many rows to fully cache - it was an assumption on my part.

Andy

|||

Andy Leonard wrote:

My apologies Sanidha,

I thought the lookup table contained too many rows to fully cache - it was an assumption on my part.

Andy

Well, yeah, that's the one thing we don't know. I want to be sure the user is selecting *just* the key, and not the whole table.

Problem with Linked Server

Hi,
I have two sql server 7.0 servers and Linked servers are created using Ole
db provider for SQL Server.
When record is added in a table in server1 then at the same time using
trigger on that table record is added in a table which resides in server2.
At this time I am getting following error.
SqlDumpExceptionHandler: Process 11 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. Sql server is terminating this process.
Any solutions?
Lalit
I posted this problem yesterday.
this problem is resloved by installing service pack 4 on
both sql 7.0 servers.
Hi,
I have two sql server 7.0 servers and Linked servers are
created using Ole
db provider for SQL Server.
When record is added in a table in server1 then at the
same time using
trigger on that table record is added in a table which
resides in server2.
At this time I am getting following error.
SqlDumpExceptionHandler: Process 11 generated fatal
exception c0000005
EXCEPTION_ACCESS_VIOLATION. Sql server is terminating this
process.
Any solutions?
Lalit

Problem with Linked Server

Dear All,
I have 2 SQL Server computers, let say Server A and B.
I created a linked server from A to B, so I can make query that the data
from Server B, and it's success.
Now, I create a linked server from B to A, but it failed.
Here's the error message:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
What's the problem with server B?
Both of the servers are using windows authentification.
Thanks
Agus
Hi
You may want to check out:
http://www.windowsitpro.com/Article/...3670.html?Ad=1
John
"Agus Setiawan" wrote:

> Dear All,
> I have 2 SQL Server computers, let say Server A and B.
> I created a linked server from A to B, so I can make query that the data
> from Server B, and it's success.
> Now, I create a linked server from B to A, but it failed.
> Here's the error message:
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
> What's the problem with server B?
> Both of the servers are using windows authentification.
>
> Thanks
> Agus
>
|||Hello,
Verify also that your account have the Windows rights on those two servers
and that they are on the same domain. The best way is having a service
account.
Hope this will help,
P. Ruello
DBA
"Agus Setiawan" wrote:

> Dear All,
> I have 2 SQL Server computers, let say Server A and B.
> I created a linked server from A to B, so I can make query that the data
> from Server B, and it's success.
> Now, I create a linked server from B to A, but it failed.
> Here's the error message:
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
> What's the problem with server B?
> Both of the servers are using windows authentification.
>
> Thanks
> Agus
>
|||I have similar problem right now with linked server.
I can run distributed query from Server A to B by using my login.
But I can't run distributed query from Server B to A by using my login.
If I run distributed query from Server B to A by using login that is
used by server B, it's success.
Why?
Thanks
Robert Lie
P.Ruello wrote:
> Hello,
> Verify also that your account have the Windows rights on those two servers
> and that they are on the same domain. The best way is having a service
> account.
> Hope this will help,
|||Hi
You may want to check out http://support.microsoft.com/?id=238477
John
"Robert Lie" wrote:

> I have similar problem right now with linked server.
> I can run distributed query from Server A to B by using my login.
> But I can't run distributed query from Server B to A by using my login.
> If I run distributed query from Server B to A by using login that is
> used by server B, it's success.
> Why?
> Thanks
> Robert Lie
>
> P.Ruello wrote:
>

Problem with Linked Server

Hi,
I have two sql server 7.0 servers and Linked servers are created using Ole
db provider for SQL Server.
When record is added in a table in server1 then at the same time using
trigger on that table record is added in a table which resides in server2.
At this time I am getting following error.
SqlDumpExceptionHandler: Process 11 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. Sql server is terminating this process.
Any solutions?
LalitI posted this problem yesterday.
this problem is resloved by installing service pack 4 on
both sql 7.0 servers.
Hi,
I have two sql server 7.0 servers and Linked servers are
created using Ole
db provider for SQL Server.
When record is added in a table in server1 then at the
same time using
trigger on that table record is added in a table which
resides in server2.
At this time I am getting following error.
SqlDumpExceptionHandler: Process 11 generated fatal
exception c0000005
EXCEPTION_ACCESS_VIOLATION. Sql server is terminating this
process.
Any solutions?
Lalit

Problem with Linked Server

Dear All,
I have 2 SQL Server computers, let say Server A and B.
I created a linked server from A to B, so I can make query that the data
from Server B, and it's success.
Now, I create a linked server from B to A, but it failed.
Here's the error message:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
What's the problem with server B?
Both of the servers are using windows authentification.
Thanks
AgusHi
You may want to check out:
http://www.windowsitpro.com/Article...23670.html?Ad=1
John
"Agus Setiawan" wrote:

> Dear All,
> I have 2 SQL Server computers, let say Server A and B.
> I created a linked server from A to B, so I can make query that the data
> from Server B, and it's success.
> Now, I create a linked server from B to A, but it failed.
> Here's the error message:
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
> What's the problem with server B?
> Both of the servers are using windows authentification.
>
> Thanks
> Agus
>|||Hello,
Verify also that your account have the Windows rights on those two servers
and that they are on the same domain. The best way is having a service
account.
Hope this will help,
--
P. Ruello
DBA
"Agus Setiawan" wrote:

> Dear All,
> I have 2 SQL Server computers, let say Server A and B.
> I created a linked server from A to B, so I can make query that the data
> from Server B, and it's success.
> Now, I create a linked server from B to A, but it failed.
> Here's the error message:
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
> What's the problem with server B?
> Both of the servers are using windows authentification.
>
> Thanks
> Agus
>|||I have similar problem right now with linked server.
I can run distributed query from Server A to B by using my login.
But I can't run distributed query from Server B to A by using my login.
If I run distributed query from Server B to A by using login that is
used by server B, it's success.
Why?
Thanks
Robert Lie
P.Ruello wrote:
> Hello,
> Verify also that your account have the Windows rights on those two servers
> and that they are on the same domain. The best way is having a service
> account.
> Hope this will help,|||Hi
You may want to check out http://support.microsoft.com/?id=238477
John
"Robert Lie" wrote:

> I have similar problem right now with linked server.
> I can run distributed query from Server A to B by using my login.
> But I can't run distributed query from Server B to A by using my login.
> If I run distributed query from Server B to A by using login that is
> used by server B, it's success.
> Why?
> Thanks
> Robert Lie
>
> P.Ruello wrote:
>sql

Problem with Linked Server

Dear All,
I have 2 SQL Server computers, let say Server A and B.
I created a linked server from A to B, so I can make query that the data
from Server B, and it's success.
Now, I create a linked server from B to A, but it failed.
Here's the error message:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
What's the problem with server B?
Both of the servers are using windows authentification.
Thanks
AgusHi
You may want to check out:
http://www.windowsitpro.com/Article/ArticleID/23670/23670.html?Ad=1
John
"Agus Setiawan" wrote:
> Dear All,
> I have 2 SQL Server computers, let say Server A and B.
> I created a linked server from A to B, so I can make query that the data
> from Server B, and it's success.
> Now, I create a linked server from B to A, but it failed.
> Here's the error message:
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
> What's the problem with server B?
> Both of the servers are using windows authentification.
>
> Thanks
> Agus
>|||Hello,
Verify also that your account have the Windows rights on those two servers
and that they are on the same domain. The best way is having a service
account.
Hope this will help,
--
P. Ruello
DBA
"Agus Setiawan" wrote:
> Dear All,
> I have 2 SQL Server computers, let say Server A and B.
> I created a linked server from A to B, so I can make query that the data
> from Server B, and it's success.
> Now, I create a linked server from B to A, but it failed.
> Here's the error message:
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
> What's the problem with server B?
> Both of the servers are using windows authentification.
>
> Thanks
> Agus
>|||I have similar problem right now with linked server.
I can run distributed query from Server A to B by using my login.
But I can't run distributed query from Server B to A by using my login.
If I run distributed query from Server B to A by using login that is
used by server B, it's success.
Why?
Thanks
Robert Lie
P.Ruello wrote:
> Hello,
> Verify also that your account have the Windows rights on those two servers
> and that they are on the same domain. The best way is having a service
> account.
> Hope this will help,|||Hi
You may want to check out http://support.microsoft.com/?id=238477
John
"Robert Lie" wrote:
> I have similar problem right now with linked server.
> I can run distributed query from Server A to B by using my login.
> But I can't run distributed query from Server B to A by using my login.
> If I run distributed query from Server B to A by using login that is
> used by server B, it's success.
> Why?
> Thanks
> Robert Lie
>
> P.Ruello wrote:
> > Hello,
> > Verify also that your account have the Windows rights on those two servers
> > and that they are on the same domain. The best way is having a service
> > account.
> > Hope this will help,
>

Problem with Link server from sql 2005 to sql 2005 - Openquery doesnt works

I have created a linked server on which following query works fine.

EXECUTE ('SELECT TOP 10 * FROM dummyOBJECTS') AT [REMOTE]

but the same statement executed with openquery

select * from openquery([remote],'select top 10 * from dummyObjects') returns following error.

Msg 7356, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI" for linked server "remote" supplied inconsistent metadata for a column. The column "dummyObjectID" (compile-time ordinal 1) of object "select top 10 * from dummyobjects" was reported to have a "Incomplete schema-error logic." of 0 at compile time and 0 at run time.

Hi ck!

Could you remove all columns except dummyObjectID and run this again?

If this reproes, could you reply with a sequence of "CREATE TABLE" and "INSERT" statements that will allow me to repro this on my machine?

Problem with Incrementing variable

I want create a Incrementing row through a variable in Derived Column Transmition,For that i created a variable called 'Increment'..in the derived column iam creating a new column with this expression

@.[User::INCREMENT] == @.[User::INCREMENT] + 1

Is anything wrong with this statement..bcoz iam getting 0 or the value which i assigned (1000)to all the rows.

Can you pls suggest some solution ?

Niru

Yeah, that won't do what you want. if you want to generate contiguous IDs then look here: http://www.sqlis.com/default.aspx?37

-Jamie

|||Thanks for the quick reply Jamie.

If I have 4 incrementing fileds in a table ,can I create 4 variables with in a single script and map those variables to respective fileds (Or) I have to create seperate script for each and every variable?

Thanks
Kumar
|||

You can do it all in one script.

-Jamie

sql

Problem with IDENTITY column

Hi all

I have a problem with a table with an IDENTITY column. In order to illustrate my problem I have created a small table according to:

CREATE TABLE [dbo].[W_Person] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[Name] [nvarchar] (50) NULL ,
[Age] [int] NULL ,
[OwnerID] [int] NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[W_Person] WITH NOCHECK ADD
CONSTRAINT [PK_W_Person] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
GO

When I create two new records, the field ID is assigned the next available value.

So far everything works fine.

THE PROBLEM:
If I insert a record with the following SQL statements:

SET IDENTITY_INSERT W_Person ON

INSERT INTO W_Person (ID, Name, Age, OwnerID)
VALUES (8000, 'John Johnson', 30, 2)

SET IDENTITY_INSERT W_Person OFF

and then deletes the same record. As a next step I tries to insert a new record and let SQL Server generate a new id, the new id is assigned the value of 8001 instead of 3.

Please, can anybody help me on this one!

//Peterhi peterand,

the identity-seed is set to 8000 after your insert. so the next value will be 8001...
if you want to re-seed, take a look at bol "DBCC CHECKIDENT"

markus

Problem with foreign key

Hello,
I have a problem with foreign key. What I want to do is , have one foreign key referencing in two different tables! I have created three tables:

create table University(
UniversityID int not null,
Name nvarchar(50),
....
....
....
primary key(UniversityID )
);

create table Person(
PersonID int not null,
Name nvarchar(50),
....
....
....
primary key(PersonID )
);

create table Borrower(
BorrowerID int not null,
Name nvarchar(50),
MemberName int,
....
....
....
primary key(BorrowerID )
foreign key(MemberName) reference University,
foreign key(MemberName) reference Person,

);

So I want to have one column (in my example MemeberName) which referencing in two different tables. How can I do that??I am not entirely sure what you are trying to accomplish, could you please reword you question a little?|||

Quote:

Originally Posted by Motoma

I am not entirely sure what you are trying to accomplish, could you please reword you question a little?

Ok, Sorry for that. Well, I have created three tables University, Person and Borrower. What I want to do is to have one column in table Borrower (lets say with name MemberId) which will be foreign key referencing together in the other two tables.
For example I gave the below syntax in SQL Server but it does not work:

create table Borrower(
BorrowerID ..........,
................,
..................,
...................,

foreign key (MemberID) references University,
foreign key (MemberID) references Person
);|||So you want the key to exist in either one of the tables? I'm not quite sure of the interaction you are looking for.|||

Quote:

Originally Posted by Motoma

So you want the key to exist in either one of the tables? I'm not quite sure of the interaction you are looking for.

ok I see. I will try to find another way. thanks

problem with exports

HI

I was trying to export a report which i created in sql 2005 businees studio to excel..the problem is that the report is in drill down format and excel doesnt show the information quiete well when i export it to excel..i really need the drill down version to b exported in excel...wat shall i do?

The Excel rendering extension handles drilldowns by writing hyperlinks in worksheet cells. The content of the drilldown report does not appear in the output of the main report.

-Chris

|||

hi Chris,

what you mean by the report does not appear in the output of the main report?

is that mean we need to create multiple report and then export them into excel for each page. then only use hyperlink to link all the report to show it have the effect of drill down?

problem with exports

HI

I was trying to export a report which i created in sql 2005 businees studio to excel..the problem is that the report is in drill down format and excel doesnt show the information quiete well when i export it to excel..i really need the drill down version to b exported in excel...wat shall i do?

The Excel rendering extension handles drilldowns by writing hyperlinks in worksheet cells. The content of the drilldown report does not appear in the output of the main report.

-Chris

|||

hi Chris,

what you mean by the report does not appear in the output of the main report?

is that mean we need to create multiple report and then export them into excel for each page. then only use hyperlink to link all the report to show it have the effect of drill down?

Problem with ExecuteNonQuery

I have created a stored procedure that takes several parameters and ultimately does an INSERT on two tables. The sp returns with an integer indicating which is positive if one or more rows were added.

If I execute the SP by hand using the SQL Server Management Studio Express I get the proper results, the records are added to both tables and the return values are proper. One is an output parameter indicating the Identity value of the main record, the return value simply >0 if OK.

However, when I use C#, build my connection, command and its associated parameters making sure they match the SP then I get a malfunction.

The problem is that when I call ExecuteNonQuery the integer value it returns is -1 even though calling it from Mgmt. Studio gives a >0 result. Even though it returns -1 I can confirm that the records were added to BOTH tables and that the output parameter (The identity) given to me is also correct. However the return value is always -1.

I have no idea what is going wrong, Since I have SQL Express 2005 I do cannot do profiling :(. I really don't see why this goes wrong and I think using ExecuteScalar is not the best choice for this type of action.

ExecuteScalar is used for database calls that return one and only one value. This sounds like what you're doing. Why don't you think that ExecuteScalar is appropriate for this?

|||

The return Value from ExecuteNonQuery retuns number of rows effected. It is better to use ExecuteScalar but not must. For execute nonquery commnd, 0th [zero] command parameter is your return value. try to access that. If you dont get then create another parameter to ur sp @.newID OUTPUT, and set that in u r sp @.newID = @.@.IDENTITY. and access that in your CommandObject after executing ExecuteNonQuery();

|||

Are you checking the return value from the ExecuteNonQuery function, or the parameter with type ReturnValue?

result=cmd.ExecuteNonQuery()

or

cmd.Parameters.Add("@.RETURN_VALUE",sqldbtype.Int).ParameterDirection=ReturnValue

cmd.executeNonQuery()

result=cmd.Parameters("@.RETURN_VALUE").Value

?

Problem with Excel 2000 and OLAP

Ciao,
I have created some cubes in my Analysis Server (SQL2000
Server) and try to retrieve the cube data by Excel2000.
In my own computer, when I create the data source in Excel, I
have not the options for "Microsoft OLE DB Provider for OLAP
Services" and "Microsoft OLE DB Provider for OLAP Services
8.0".

I have installed the Analisys Services..

Can anyone help? Thanks!

FabrizioHi Fabrizio,

below is the step i use retrive cube data from excal 2000.

1) in Excel 2000 click Data --> PivotTable and PivotChart Report
2) in pivot wizard step 1, choose external datasource.
3) click get data
4) click <new datasource> at OLAP CUBE tab
5) select OLAP Provider.
6) select Microsoft OLE DB Provider for Olap Services 8.0
7) click connect --> analysis server --> enter server name
8) it should display a list of OLAP database, select your database & cube.

cheers,
suhfui|||Sorry but I haven't Microsoft OLE DB Provider for Olap Services 8.0.
Why?

Thank you|||You need to install PTSFull (Pivot Table Services) on your client as well.

It can be found in SP3 for Analysis Services in the folder

sql2kasp3\msolap\install\PTS

the 8.0 version is available after that.

HTH Lutz

problem with dynamically created RDL files and reports

Hello,

I have a strange problem with a dynamic created RDL resp. dynamic created report.

I have followed the programming tipps on the microsoft site to create programmatically a RDL file and this RDL file is accepted by the reporting server. But when the report is rendered out of that RDL some fields are somehow modified. In one field after the first line (which holds the correct value) all values in the following rows are cut after the fifth character. Other fields contain every now and then strange signs like a caret...

My report items in the RDL e.g. look like this:

- <TableCell>
- <ReportItems>
- <Textbox Name="Details_PBN">
- <Style>
<TextAlign>Left</TextAlign>
<FontFamily>Courier New</FontFamily>
- <BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Value>=Fields!PBN.Value</Value>
</Textbox>
</ReportItems>
</TableCell>

Do I have to do some datatype conversion in my RDL when I create it or how could this be possible?

Any help appreciated!!

I solved it myself. I write the solution down here, perhaps someone else has the same problem.

The data I that is in included in the report is queried from an oracle database. I also created the datasource for the report dynamically and there I used the provider "Oracle". This seemed to cause the problems, because after I changed it to OleDB and uses Provider="MSDAORA.1" as provider in the connection string, it worked like intended.

so... Code on, folks!!!

Problem with displaying workflow?

Hi,

I just recognized a strange displaying problem in one of my SSIS jobs.

I created job which contains a sequence container. Within the sequence container there is one "Execute SQL Task" and one "Foreach Loop Container". Within the "Foreach Loop Container" there are 4 task which are connected with precedence constraints.

Now my problem is that if I load the SSIS job and open the "sequence container" while the "Foreach Loop Container" is already open then the precedence constraint won't be displayed. If I close and open the "Foreach loop container" again then the precedence constraints will be displayed again.

My first assumption was that it might be a problem with the display drivers of the computer ....however the problem appears also on any other computer.

Does anyone know how to solve this display problem without closeing/reopening the container?

Thanks,

StSt

StSt,

You just have to lump it I'm afraid. It happens from time to time.

-Jamie

Problem with db connection

My application works properly with development area (VS 2005) , When I created virtual directory and call using browser (IE 7.0) , error occurs exacly the same below

ERROR:

Cannot open user default database. Login failed.
Login failed for user 'CBOZLAGAN\ASPNET'.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'CBOZLAGAN\ASPNET'.

Source Error:

Line 4932: this.Adapter.SelectCommand.Parameters[2].Value = ((int)(PROFIL));Line 4933: neuron.KULLANICI_TANIMLARIDataTable dataTable = new neuron.KULLANICI_TANIMLARIDataTable();Line 4934: this.Adapter.Fill(dataTable);Line 4935: return dataTable;Line 4936: }

Connection String is below

"Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\neuron2007_AJAX\\App_Data\\neuron_Data.MDF;Integrated Security=True;User Instance=True";

How can I solve this problem?

Thanks

Did you grant the ASPNET user account permission for the database?

Jeff

|||

Are you publishing to a remote server and are you publishing a copy of the local database that you are connecting to in that connection string?

Did you grant the correct permissions for Integrated Security?

|||

Yes BRCK231\ASPNET has rights below

- db_datareader

- db_datawriter

But connection is done with user BORINTERNAL\CBOZLAGAN for BRCK231\SQLEXPRESS sqlexpress 2005 server

|||

Is the website set up (via IIS) to accept anonymous connections? If not, please give that a try.

Mark

|||

Did you figure it out yet?

problem with datetime value as parameter value

Hi all,
I created a stored proc that has input datetime parameters (begindate and enddate), I tried the command: exec storedproc '20060320' in the query command part in Microsoft SQL Server Management Studio and it works but when I try to create a report dataset using the stored proc and execute it using value 20060320 it does not work. I even try using '20060320' and "20060320" as the value and it did not work also. I received the following error:
TITLE: Microsoft Report Designer

An error occurred while executing the query.
Failed to convert parameter value from a String to a DateTime.

ADDITIONAL INFORMATION:
Failed to convert parameter value from a String to a DateTime. (System.Data)

String was not recognized as a valid DateTime. (mscorlib)

BUTTONS:
OK

Anyone have any idea on how can I solve it or go about it? Thanks in advance.
Daren
Try using the format: "mm/dd/yyyy", so it would be: 03/20/2006.|||Thanks Deepak,
This solved my problem.
Daren

problem with DateTime picker

Hello.
I've just created a new report and I added a prameter of type "DateTime".
I didn't even used it in the query.
Whan I preview the report I have the small calendar Icon.
after I pick a time from the picker And press "View Report"
I get the error:
"the value provided for the report parameter P1 is not valid for its type"

I'm using RS 2005.

Any body know whats the problem?

Thanks in advance,
Roy.

Does this happen for any DateTime you pick, or only certain ones?

Can you type in a Date, say, "1/1/2005" and successfully render the report?

Does the same thing happen when you publish the report and view it in Report Manager?

|||Hi Mike.

I think I know whats the problem.
Whan I run it an my local Pc its take the date in a diffrent format.
Whan I choose 1 in february I get in the box 2/1/2007.
instead of 1/2/2007 like it should be since I'm with hebrew settings.
So the problem is that if I choose 13 in february I get it as 2/13/2007 whice give the error since there is no 13 month!
Any way, when I deploy it to the server It was Ok from some reason.

So Its look like a little bug of yours.

Thank for the replay,
Roy.

problem with dateTime picker

Hello.
I've just created a new report and I added a prameter of type
"DateTime".
I didn't even used it in the query.
Whan I preview the report I have the small calendar Icon.
after I pick a time from the picker and press "View Report"
I get the error:
"the value provided for the report parameter P1 is not valid for its
type"
I'm using RS 2005.
Any body know whats the problem?
Thanks in advance,
Roy.On 15 Feb, 08:30, "nicknack" <roezo...@.gmail.com> wrote:
> Hello.
> I've just created a new report and I added a prameter of type
> "DateTime".
> I didn't even used it in the query.
> Whan I preview the report I have the small calendar Icon.
> after I pick a time from the picker and press "View Report"
> I get the error:
> "the value provided for the report parameter P1 is not valid for its
> type"
> I'm using RS 2005.
> Any body know whats the problem?
> Thanks in advance,
> Roy.
Hi Roy I had this too and it was the date format that the picker was
sending to the dataset query.
I got around it by formatting the datepicker value to be the same as
the sql table date format ie
I hope it works out for you.
SELECT loaddate ,*
FROM tbl_T
WHERE convert(varchar(12),tbl_T.loaddate,103) LIKE
convert(varchar(12), (@.LoadDate),103)|||Hi Caseywill,
Thanks, I also discover that I have a problem with the format.
Whan I choose 1/2/07 which should be the 1 in february I get in the
textbox 2/1/2007.
So when I choose 13/2/2007 which should be the 13 in february I get
2/13/2007 which give the error since it looks for the 13 month (I have
hebrew date settings).
I don't know how to fix it since the datepicker doesn't choose its
date from a query.
Any way, When I deploy it It seeems to be ok and only on local pc it
give me some problems.
Thanks for your replay.
caseywill67@.googlemail.com =D7=9B=D7=AA=D7=91:
> On 15 Feb, 08:30, "nicknack" <roezo...@.gmail.com> wrote:
> > Hello.
> > I've just created a new report and I added a prameter of type
> > "DateTime".
> > I didn't even used it in the query.
> > Whan I preview the report I have the small calendar Icon.
> > after I pick a time from the picker and press "View Report"
> > I get the error:
> > "the value provided for the report parameter P1 is not valid for its
> > type"
> >
> > I'm using RS 2005.
> >
> > Any body know whats the problem?
> >
> > Thanks in advance,
> > Roy.
> Hi Roy I had this too and it was the date format that the picker was
> sending to the dataset query.
> I got around it by formatting the datepicker value to be the same as
> the sql table date format ie
> I hope it works out for you.
> SELECT loaddate ,*
> FROM tbl_T
> WHERE convert(varchar(12),tbl_T.loaddate,103) LIKE
> convert(varchar(12), (@.LoadDate),103)