Is there a way in DTS to create a destination table based
upon the format of a text file source?

In the transform data task, you can use the Create Table
button to do this, but I would like to automate a package
to create a table with a changing source file for each
execution. What is the Create Table button doing to read
the source file?

Thanks,
Susan

In article <034e01c35ab9$d6e8b390$a301280a (AT) phx (DOT) gbl>, Susan
<soconnell (AT) aspirity (DOT) com> writes
Unfortunately the Create Table options and the associated logic to parse
the file and generate a table structure is only available at
design-time, so there is no way of automating this in pure DTS. You
could of course write your own code to parse the text file and generate
your own create table statement. This could be done in an ActiveX Script
Task or perhaps a custom task.

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