Problem solved..this time it was the wrong instance name 🙁

Thank you for the reply..but then why I am not able to log into the local server 🙁

Its a fresh installation..

OK..Problem solved..solution was converting the data to Integer 😀

silly me..Thanks a lot guys 🙂

Thank you so much for the reply guys..

As many of you suggested..I restarted the services..then rebooted the computer..but still nothing worked..

I changed the values of x and y axis, but...

I am have got the contents of the objct variable in a string variable..Now I am using a script component as source so that I can pass this string variable...

Thank you so much guys for the wonderful replies.. 🙂

Koen Verbeeck (3/30/2012)

---

You cannot use the object variable directly like that.

I would read from the source with the following query:

SELECT col1,...

Thank you for the reply guys..the problem was EvaluateAsExpression was not set to true..its working now..thanks again for the help 🙂

The root cause of the problem was equal to sign provided before the expression..I removed that sign..and the error was gone..

Thanks for replying mate..The variable type is String only..and an extra space before Order by is not helping.. 🙁

anyways..the problem has been solved..the date was not casting to string properly..and thats why I was getting the error..so the following expression worked..:-D

@[User::FilePath]+@[User::FileName] +"_"+ @[User::Plan_ID]

Thank you buddy for your valuable feedback..as per your suggestion..I am trying to do it using Flat_File_Destination only..so I created a new flat file connection manager..gave it a path of...

Any ideas guys..

LoLzz..when you see the report on the server there is a small arrow at the center+top of the report..click it and you will see the parameter..case closed

Forgot to mention..The parameters are showing up in BIDS when I preview the report..but the problem arises when I deploy the report on the server even though I have checked...

So I think I should move ahead with this exam only..any other suggestions..

btw Thanks a lot guys for the wonderful suggestions..It certainly helped me 🙂