yes, there's one in dts bulk insert task
but it requires the same number of cols for source & destination.

are there any other alternatives on the market?

In message <e#eLCqnYEHA.3012 (AT) tk2msftngp13 (DOT) phx.gbl>, Alexander Nenashev
<nenashev (AT) hotbox (DOT) ru> writes
I have two methods -

SQL - write some SQL that produces it from a SELECT statement, useful
when generating it from a SQL structure. Copy and paste text output into
a file.

Excel - I often use this as it easy to setup the correct data in a
spreadsheet, and then save as text to get a valid file.

Not what you really wanted maybe, but they both work pretty well.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org