I want to use DTS Wizard to map columns between a source table and a
destination table and then extract the sql statement created. For example, I
want the insert sql statement from table Source to table Destination which I
use DTS wizrad which columns from Source should insert into which columns of
Destination.

Thanks.

Hello Peter,

Ok So the SourceSQLStatement property of a Transform Data task will hold
the select method used. It may however hold only an object name in which
case the statement will be

SELECT <ALL COLUMNS> FROM <OBJECT>

If you choose to type the statement you want to use then it will return that.

Does this answer what you want?




Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com