Thank you all for your valuable replies and solution. They are very helpful.:-) I am glad that you were able to understand the problem I was having as I was...

thanks. I will try this too. Only thing is my procedure will be very log.

How about using style 120 .Any pros/cons?

The format of my procedure is as follow: if not converting to varchar in orderby then I ma getting error in ssrs 2005

create stored procedure testsorting

( @sort varchar(60)

)

as...

Yes, In ssrs teh input parameter is a string because i have to pass teh values like "date", "name" to teh stored procedure when the user select what i want...

Hi All,

Thanks for your replies. Actually I am using SSRS to develop a report and I need to sort the data based on a sort input parameter the user select...

Hi,

Thanks for your reply. The package is an old DTS package and I need to migrat eit to SSIS 2008. Actually, the cubes will eventually be moved to SSAS...

Thank you for your reply. I have never used DSO, so not familiar with it. Is the script is a VB script? How should I create it in SSIS?

I was...

I am sucessfull when I try to connect to the Analysis services 2005 cubes in SSIS 2008, and it also lists the different objects available.

But when I connect to the...

Hi all,

I was following this thread as I am also using config files but they are still in the development stage on my system. So, for development purpose we need...

Thanks a lot for your reply. I am thinking of using "Analysis Service processing" task in SSIS 2008 to process analysis services 2000 cubes. But I am getting a connection...