Is that u can change the Datatype of the Destination ,if so then sink both the source and destiantion datatype to same ,

IF "ID" is integer convert into...

Its like qty booked in advanced so that the values has to appear in the charts ,

the Below is the Error that i get

Description: The file name "\\tsclient\D\Data\2160_data.xls" specified in the connection was not valid. End Error Error: 2010-09-27 14:24:09.29 ...

Thanks For the Solution i used Running value Function that is in SSRS,

Hi,

Its Just an excel File :

Order No | Date

F000987 | 23/10/2009

F000101 |res in

JkP0091 |10/10/2009

when i import this 2 column in the sql server table i get like this

Order...

Hi,

Its Just an excel File :

Order No | Date

F000987 ...

I found the solution for my question....

I like to share .....with u'll

Its mainly bcoz of the column names ,as the column names had square brackets and double quote respresenting ....

As...

Thank you so much ....I got the results ...As u said i took up the first option...

it worked Fine ...

Jaya

If i run your quey ,i get a constant values for the column MemoryPages_1

say for any dateTime ,the column values seems to be the same..

there is no any PK or Fk relationship between this two tables ,or any column been identical,

thanx

Jaya

Hi ,

the first column is of DateTime

The second column is of varchar datatypes.

thanx

Jaya