You can generate a Format file from the task itself but this is limited.

You could then take the format file and by doing a search on the web alter
it to meet your needs.

There are examples of doing this if you Google

--

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

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Mtz" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Whilst using the "Format fiel" option results in an error ("Invalid column
number in format file").