Post reply

insert into vs data flow task

  • October 15, 2008 at 4:10 am

    #131718

    I have a table with a column nvarchar(max)

    This table has 43000 rows.

    Execution time:

    insert into server2.db2.dbo.table

    select * from server1.db1.dbo.table

    1 minute and 30 seconds

    with wizard export data, 27 minutes.

    why?

    thanks for all.

  • October 17, 2008 at 11:39 am

    #886538

    The answer is overhead, but I guess that's obvious - maybe someone else can chime in about exactly what all the overhead is. Save the data flow task for when you need it for transformations. If ExecSQL will serve your needs, use that.

    [font="Courier New"]ZenDada[/font]

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

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