I have 4 flat files which I am receiving updates for on daily basis. I have currently used SSIS to import these files into SQL Server 2005 and have created dtxs files for each one.
Is it possible after the first run of the configed dtxs files (each import a flat file to a SQL Server 2005 DB) to automate this process so that imports can occur on a daily basis even if columns are removed/added to future flat files? If so please explain how this is done (In detail, pictures would be nice).
Just to clarify my vendor has told me that they will remove or added different columns to these flat files at any time. I do not want to recreate my orginal dtxs files, each time this occurs.