can u help me with detailed procedure or any sample data if u have

yes but thats just a command line where in if we go by Data flow task then there would n number of files with source -destination linking and wont it...

thanks for the options but what if in future the number of files increase

with increase of files the data flow tasks would look messy with individual source -destination

...

ok you help me out which is better way out to solve this issue of 25 different format files to be imported into 25 different tablesof s1l database dynamically,

yes now you got it the bcp.exe process , can you help with that procedure of creating XML format file , assign variable to import, change format of imported files...

thanks for the revert however i know the procedure informed but to get this dynamically i assume there is procedure of format files with xml format and then script to...