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

2 Answers  

---

What do mean by xml datatype?

0 Answers  

---

How m-m relationships are implemented?

2 Answers  

---

What are the pros and cons of creating extended stored procedures?

1 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers  

---

---

What is filestream?

0 Answers  

---

What is a transact-sql statement?

0 Answers  

---

Determine when an index is appropriate?

0 Answers  

---

Differentiate between sql temp table vs table variable?

0 Answers  

---

What is Report Server,Report Manager and Report Builder in SSRS 2005?

1 Answers  

---

how to select a field with firstletter as capital and remaining are small letters

11 Answers  

---

What are the four main query statements?

7 Answers   Wipro,

---