I have a .csv-file which is imported into my database using DTS.
When look at the DTS package in design-mode i can see that it creates a table and then copies the data from the file into the created table.
Nothing wrong there.
But when the contents of the file changes (e.g. column added or removed) the create table script raises an error. The script is not dynamic, it is created when the package is created and only changes when the package itself is re-created.
Is there a way to make the create table script be dynamic so that the table is dropped re-created according to the format of the .csv-file?
Thanks for your fast reply, but i don't want to change the name of the file but the data in the file. I created the DTS-package and in it is a create table task. When i change the contents of the file by adding or removing a column the create table task is corrupt because it creates a table where there's a column too many or missing.
Because the contents of the file can be dynamic i want the create table task to be dynamic.