A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

2 Answers   Sapient,

---

You want to implement the one-to-many relationship while designing tables. How would you do it?

0 Answers  

---

What is right outer join in sql server joins?

0 Answers  

---

What does it mean if @@cursor_row returns a negative number?

0 Answers  

---

Is it important for a database administrator to understand the operating system and file access?

0 Answers  

---

Can a table be created inside a trigger?

0 Answers  

---

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

0 Answers  

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

0 Answers  

---

What are the differences between local and global temporary tables?

0 Answers  

---

What are the approximate numeric data types?

0 Answers  

---

What are the difference between primary keys and foreign keys?

0 Answers  

---

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

0 Answers  

---