How do you connect 100 files as a flat file sources in one
package of SSIS?

Answer Posted / ramesh

using for each loop and iterate each file in that folde or object

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happens when converting big values to numeric data types?

565


What are scalar functions?

503


Do you know what are pages and extents? : SQL Server Architecture

548


What is the difference between rank and dense_rank?

503


What is a join in sql? What are the types of joins?

521






What is raiseerror? What is raiseerror?

639


Explain different types of self contained sub query?

543


Do you know what are the steps to process a single select statement?

530


How to create a scrollable cursor with the scroll option?

494


Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

539


How to find the second highest salary of an employee?

587


Define tool Manage Statistics in SQL Server 2000 query ?

524


Can we join two tables without primary key?

609


Do you know what is a with(nolock)?

600


What is row_number () and partition by in sql server?

519