its not working(may be I am doing something wrong)
instead what I did is I moved all the cascading parameters to the top.
and kept independent parameter in the bottom

This is the interview question I faced 2 days back.

Thank you very helpful.

Thank you very helpful.

ok I will go with that

yep sorry i mentioned everything except ssrs yeah its in ssrs.

in ssrs when you add dataset and right click and select fields option and click add there are two option...

then try this one if u want to use *--

create procedure startrred

@hourstarted varchar(10)

as

begin

if(@hourstarted!='*')

begin

Select *

from Production where hourworked>@hourstarted

END

else

begin

select * from Production where hourworked>15

end

end

thanks al i added destination config and i copied the ssis file its running fine

hi added destination conection ya everything is fine thank you all

ya when opend the package

destination was showing error then

i edited it

after i started ssis package no error was their

but i dont want do do like that

..

i just...

i did same thing copied everything .

started the package edited the source in connection string in config file

while running no error is about source connection string

but destination connection login...

actually i deployed the package and tried to change xml but there is no xml .config in c

how to move that one

is arcplam is a good tool to work on ?

is there any openings related to it?

whats your opinion on ssis ???

i am working as report developer ??

I have 1 1/2year exp in ssrs reports and

now recently i joined ssas and ssis job??

is it...