Export every one hour update table data between two sqlserver 2005

  • How to export every one hour update table data between two sql server 2005

    Hi,

    Please help me with a script or procedure for my requirement.

    SQLServer 2005, i want every one hour table data to be export from source table to another sqlserver 2005 database table (same database at destination) .

    On source table, weekly twice we are truncating the table data, so we want to export the data to another table at destination as copy of data(backup for our original data).

    I want to create a SSIS package and need a script for my requirement.

    Thanks in advance

  • You can use the Import/Export wizard of SSMS to create an SSIS package. Then schedule this package in a SQL Server Agent job.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Thanks for your response,

    I tried with import\export wizard, but i need a select query with condition where it can export only updated every one hour data between two tables (soruce,destination).

  • sobhan.ksb (3/29/2011)


    Thanks for your response,

    I tried with import\export wizard, but i need a select query with condition where it can export only updated every one hour data between two tables (soruce,destination).

    You can create the SSIS package through the Import/Export wizard and then edit the package to adjust the select query with the condition.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply