Dynamically Create SQL Fields in SSIS 2005

[Matthew Wieder]

How would I go about creating an exact replica of a dBase file as a SQL
table? Using SSIS, I can create the data source from the dBase file, but it
will only let me import into a SQL destination if the table is defined and
the columns match up. How can I dynamically create the needed SQL structure,
so that it is created automatically based on the columns which exist in the
dbf file?

[Todd C]

The Import/Export wizard in SQL 2005 might be of use there in that it should
be able to read the meta data of the source and recreate it in the
destination, if everything (data types) is a good match. However, once
created, the package will be static. You could not expect it to be run again
AFTER making changes to the source meta data and have those changes
propagated to the destination.

Sorry, SSIS is not that smart.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]

Post by Matthew Wieder
How would I go about creating an exact replica of a dBase file as a SQL
table? Using SSIS, I can create the data source from the dBase file, but it
will only let me import into a SQL destination if the table is defined and
the columns match up. How can I dynamically create the needed SQL structure,
so that it is created automatically based on the columns which exist in the
dbf file?