Pls solve my following query with example.
now i am doing project using ssis 2005. in that
1. import data from multiple resources like .xls, .xml,db
2.Read only file path from created meta data table like dil_table_met (Filetype=.xls,filepath=c:\..)
3.In that meta table, i want to read only file path and check file path which filetype like .xls or .xml and then import to excel source and to db destination , the same via for all file type
4. next read data from resources import correct data into correct table and wrong data into error table
5.for all these above condition are in loop.
pls give a example for this its very urgent
pls pls help me out for thisR.Vinothraja
View Complete Post