Thank you CozyRoc,

I am sorry but I cannot find 'add references' under 'Project' in Visual Studio 2005.

Take care, @+ JP

[font="Courier New"]INSERT INTO [TargetDB].dbo.[tbl_target]

SELECT * FROM [SourceDB].dbo.[vw_source][/font]

The query gave me an execution time of... 11-12s

This is great - Thank you CozyRoc! This is indeed a good solution for...

Not at all. Would you recommend to "INSERT INTO FROM (SELECT)" approach?

The concept would in the end to have this ETL component (without the T...like you mentionned) part of a...

[font="Courier New"]SELECT @@VERSION

--------------------------------

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2...