yes you are right..on a 64 bit sql server..u will need 64 bit 10g client to connect linked servers..and if your SSIS or DTS packages are using open query to...

i got the solution..thanks for answering...

thanks...it helps..

thank you for responding..no Chidambaram it is not connecting to any webservice...it is just a simple Send Mail task...i will also try restarting the agent service..thanks..

u can use db mail in DTS package suing xp_sendmail..DTS has to be legacy component

thanks manu..that is what i exactly did..but their is limitation on file attachment..is there anyway i can still use SQL mail in a 64 bit 2005 sql server..please let me...

awesome xanthos...it worked for me..thanks

thanks everyone for taking time and answering my question....when i right click on db and under custorm rpts/ schema schanges history..that gave me everything...it is just that i think it...

hey i tried on my laptop..it doesnt shows the table which has been dropped.....is there anyway to find the table name also..thnx

thanks...i will try this tomm and let you know.,..thanks..

Hello...thanks for answering..yeah i figured that out that we need to open each package and change the source...thanks..

i found it out from one of the posts in this forum..i knew that i have to select Operating Cmd option in order to execute a DTS package as a...

thanks for your reply......i think you mistook my question....jobs are mgrated from 2000 - 2005..the packages are copied not migrated..so they are still legacy components...the migrated jobs will run using...

nope..thanks

how do i create a record set object ...please let me know..thanks..