hi I want to port data from different file format source to one db... Pls help me to achive this...

What would that mean metadata of files is different or the format is different, like .xls, .txt if file formats are different make speperate connection managers for each file format and export the data, however if the file formats are same and metadata is different this is best acheived via a script task or you can read whole of the data as a single column and then divide it as you want to. Abhinav http://bishtabhinav.wordpress.com/

Please provide more details... by default you need a data flow task for each file... if files have the same format you can use a Foreach Loop. If you want to use a foreach loop check out this thread: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/ec7a6adb-2a52-49ba-8cde-56f67f2fc4d9/#0a8af7cf-9b13-43ab-a7ea-c9262dcef5f4 That foreach loop example uses a Regular Expression to filter. This allows you to filter on multiple file extensions like *.txt and *.xls: ^.*\.(txt|xls)$. Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter