RunnerNwizard
asked on
Automating using SSIS (DTXS files) to import FLAT FILES
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.
Questions:
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.
Questions:
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.