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...

What does truncate do?

0 Answers  

---

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers  

---

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

2 Answers  

---

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

2 Answers   IBM, TCS,

---

What is collation sensitivity?

0 Answers  

---

How many types of indexes are there in SQL Server?

6 Answers   CarrizalSoft Technologies, United Healthcare,

---

What command is used to delete a table from the database in the sql server and how?

0 Answers  

---

What is the use of =,==,=== operators?

0 Answers  

---

What the class forname () does?

0 Answers  

---

Do you know what guidelines should be followed to help minimize deadlocks?

0 Answers  

---

What do you understand by the data quality services in sql server?

0 Answers  

---

In which format does an image save in SQL Server database ?

0 Answers   MCN Solutions,

---