I am begineer to the SSIS package, can anyone help me to resolve this apporach.
I have a different files with different extension like tbla.txt,tblb.txt,tblc.xls and tbls.csv in a same folder. I would like to upload these files into different database tables. for example tbla.txt should upload to tbla table, tblb.txt file should
upload to tblb table and so on. I have used flat file source to OLE DB destination asa Dataflow for the each file. It works well. However if the new file is added to the folder again i need to modify the pacakge to include another dataflow.
I dont think it is a best approach, Can anyone have a best approach to implement this?
View Complete Post