• Thanks Phil..

    Forgot to inform that i need to use SSIS 2005. So that i can schedule it in SQL Server Agent job to run on daily basis.

    How do we transfer data using SSIS 2005

    Regards

    SqlStud