You want to format it in the expression or you want to convert it while retrieving from SQL???

Hey thanx.. I worked out this way only by using Union with NULL....

But I am still not able to find why its not showing me NULL in dropdown without...

Well you can achieve this with both ways... but Slowly Changing Dimension is preferred.!

Are you searching for table - dbo.sysdtslog90

Well Thanx for the help Steve but that too didn't work for me...

What I did is I created staging table, and on that table I used conversion functions in SQL...

Hi Jack,

Reporting Services account do have access on FTP server.... I don't know whats going on wrong..! :doze:

Well I got a root cause of this problem in my case...

In typecasting it used to give me error becuase microsoft had released one patch for SQL Server 2005 which...

Wll I tried that too.....

the field is coming from text file and reading it as string as of now...

Hey Goran,

I tried the way you told in SSIS Derived Column Transformation with little modification as per req. but it didn't work.

DATEDIFF("Millisecond",(DT_DBTIME)"00:00:00",(DT_DBTIME)Field1) / 1000.0

I tried data types as DT_DBTIME,...

I am not pretty much clear about your package design :unsure:...

Are the dataflows running in parallel? Have you created single connection for all dataflows or all are having individual...

Hi,

Me.VariableDispenser.LockOneForRead("MAXRESER", var) works for vb.

To use same in C#, just use this instead of me. 🙂

I am not sure about it but see if the below link helps you -

http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/a2a598e4-5fab-42d4-aaa7-b4f40542c958

Regards,

Saseen

Nope.. None of the number is negative...

X-Axis are like -

00:00:00

01:00:00

02:00:00

.

.

.

23:00:00

and Y-Axis are like -

0

10

20

.

.

100

Hi Slawek,

I can't use this option I dont have permission on other server apart from select.

But I found another way to achieve this.

May be if you are interested in...

Hi Martin,

Your solution worked really well for me... !!!

Thanks a lot for the efforts you took to try this.. 😎

Hey Raunak,

I dropped idea of not using linked server because...