could you tel me which task/transformation i have to use in SSIS package for send messages from SQL SERVER to mail..

Hi..Thanks to all for giving your inputs.

I believed that all sql server services will automatically stopped and restarted in the time of rebooting..But i don't know in our team...

Hi sushant

I have checked in sql server error...

Hi..

I am sure i have entered correct pwd and also my server using mixed mode..

Thanks Koen ...I have changed schema name with new one using below one

ALTER SCHEMA <NEW SCHEMA NAME> TRANSFER <OLD SCHEMANAME.OBJECTNAME>

import/export method is also ok for me

Thanks Gianluca Sartori & Lowell ..

I want to go by SSIS for migrating Oracle data(only tables) to Sql Server rather than by SSMA ..

I don't know SSIS much..Is there any...

could anyone provide the step by step process for migrating the oracle data(only specific objects) to Sql Server using SSMA tool..

Thanks

Okay...For working with SSIS first can i create linked server between sql server to oracle and then proceed or directly can i use the ssis for migrating oracle data to...

To my knowledge..Sql Server 2000 doesn't work on windows 2008..

If you have Sql server 2005(64bits) ,it will supports up to 1 TB data..So no need to configure the AWE

You had better to configure AWE setting..no matter whether you have 4GB,16GB,32GB..Max memory used for Sql Server was only 4GB..You can overcome 4GB by using AWE

Hi Markus..agree with you...But you know what i mean , if you take some scenarios like ..

My database is crash unfortunately and i have .bak file for that database..So...

yes..simple way to tranfer the table using import/export wizards

usually differential backups treated as an incremental backups..i don't think both are different..

In sql server if anything modified after taking the fullback it will be recorded in page as...