Post reply

SSIS Package or Script

  • October 5, 2010 at 11:31 pm

    #239283

    I do have one table in server - Production Server name.Table1

    and second table in dev server- development server name.Table2

    I would like to Truncate the table in Development server and insert into table2 from table using SSIS, so i can use them in future for regular use, how can i do that?

    Thanks in advance

  • October 5, 2010 at 11:45 pm

    #1232248

    A EST(Exec SQL Task) would solve your need

    Raunak J

  • October 5, 2010 at 11:48 pm

    #1232249

    I have to truncate the table2 and insert into table 2 from table1. As that regular task.Data will be replicate from Production server to Development.

  • October 5, 2010 at 11:52 pm

    #1232250

    Still EST will solve your need:-)

    Raunak J

  • October 6, 2010 at 12:50 am

    #1232274

    Hi Raunak

    Can you please elaborate the steps?

  • October 6, 2010 at 9:50 pm

    #1233252

    Sure. Described as below:

    Step 1: Add a Linked Server

    Step 2: Using Open Query

    But after reading your original post, which says you wish to manipulate data in the production server.

    Be cautious. A better approach would be to implement temporary data staging model.

    Raunak J

  • October 7, 2010 at 1:51 am

    #1233296

    1. Create EXECUTE SQL TASK and write TRUNCATE TABLE table2

    2. Create DATA FLOW

    Source (table1[Production]) ----> Destination (table2 [Development]

    Connect EXECUTE SQL TASK with DATAFLOW.

    And then schedule this package accordingly.

Viewing 7 posts - 1 through 6 (of 6 total)

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