okkk!!!

What u can do is create a sheet with all the formulas and put it at a particular place say d:/temp/myexcel1.xls , before transgerring data from ssis just...

Are you talking abt generating formulas from db?

If no you can do that by using macros in excel.

Thanks a lot!!!

Just one confirmation needed i will have to create this table before right UpdateDBStatsStatus?

and i will have to run it once in a day,right?

so it...

Thanks a lot Mr or Mrs. 500 !!!

i got some result but the probleme is i am not able to analyze it.

TroyK ,

Thanks a lot for your kind reply!!!

Ok now...

Thanks a lot for all your replies!!!!

SSCrazy,

Its not something that i am letting you people to do my...

Yes.

You can go for MCTS that is microsoft certified technology specialist in sql server 2005...