 | We recieve multiple data files in different file formats from
different sources. Currently we load them using DTS packages, but the
problem is now we have got more then 120 DTS packages to maintain. Is
it possible to writs a single DTS package which loads all the file
formats into a staging table and from there I can manipulates data as
required.
The diff. file formats are like .txt .csv .xls .dat etc
Some files comes with header info and some without
txt and dat files comes with different delimiter
The whole point is to reduce maintanance work because we recieve 200
files every day to load and our vendor frequently change file formats
without giving us adequate time to stop the automated dataloading
process.
Thanks in advance.
Subodh
|
|
