I need to create several hundred DTSX packages and would like to create these automatically.
The source tables are text files in Microsoft Windows? and the destination tables are in SQL Server.
The source and destination table names (together with their locations)would be loaded into a file. This file would then be read and, for each source/destination record read, a DTSX package would be created.
The source tables would all have identical column names.
The? destination tables would all have identical column names.
The DTSX data mappings would all be identical.
Only the source table and destination table names would be different.