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

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

---

How to change a login name in ms sql server?

0 Answers  

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

0 Answers  

---

What are views in ms sql server?

0 Answers  

---

syntax and example for bitmap index in sql???

1 Answers  

---

---

two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 Answers  

---

What is a cube? : sql server analysis services, ssas

0 Answers  

---

what operator performs pattern matching?

2 Answers  

---

write an SQL query to list the employees who joined in the month of January?

0 Answers   Agilent, Amdocs,

---

How to modify existing triggers using "alter trigger"?

0 Answers  

---

What does the on delete cascade option do?

0 Answers  

---

How is sql server used?

0 Answers  

---