Answer / ramesh

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

Answer / prashant

if you mean merging 100 flat files into one, you may
try "Union All" component if the data is similar.

Here's how:

1. Create Flat File Sources for each file.
2. while creating Flat file connection, don't forget to
mention that the first row is columnname.
3. Edit "Union All" component and select all the Input
field names (from all the columns).
4. Point the output to either to a OLEDB or another Flat
destination, map the fields...

How to access the inserted record of an event?

0 Answers  

---

Explain how to use linked server?

0 Answers  

---

Does partitioning ssd reduce performance?

0 Answers  

---

What is use of except clause? How does it differ from not in clause?

0 Answers  

---

How to start sql server browser service?

0 Answers  

---

Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

---

What do you understand by triggers and mention the different types of it?

0 Answers  

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

0 Answers  

---

What is difference between rownum and rowid?

0 Answers  

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

What are the properties of primary key?

0 Answers  

---

What happens on checkpoint?

0 Answers  

---