Post reply

package to truncate and update data

  • August 10, 2010 at 12:51 pm

    #227627

    Hi,

    I need help in creating a package which copies data from one table in one database to another table in another database.

    The above one is simple but the tricky part is

    if the destination table already contains some data in that then that package should delete all that data and copy the data form source table.

    I couldn't figure out how i can do that in SSIS

    Thank you...

  • August 10, 2010 at 1:51 pm

    #1205017

    Import Export wizard is the easiest way.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • August 10, 2010 at 1:57 pm

    #1205022

    ya import export wizard is easier but i need to use SSIS to design that package as i got more tables and also i need to use sequence container...

Viewing 3 posts - 1 through 2 (of 2 total)

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