Home Forums SQL Server 2005 Business Intelligence Import from multiple Flat and excel files in the same folder RE: Import from multiple Flat and excel files in the same folder
Kumara1011
SSC-Addicted
Points: 424
More actions
November 28, 2012 at 12:42 am
#1562951
small example :
right("D:\\filesource\\emp1.xls",3)=="xls"
right("D:\\filesource\\emp1.txt",3)=="txt"
mention this condition in precedence constraint to send text files to one destination and excel to other destination using same table in OLE DB.