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,

---

What is Replication?

0 Answers  

---

Tell about MOM Tool(Microsoft Operator Manager)?

0 Answers  

---

Can you name some of the dml commands in sql?

0 Answers  

---

Do you know spatial data types - geometry and geography in sql server 2008?

0 Answers  

---

What is the recursive stored procedure in sql server?

0 Answers  

---

What is the maximun sixes of .mdf in sql server 2005

1 Answers  

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

what is datawarehouse?

0 Answers   Informatica,

---

what is the order of execution of where,having,group by in select stement

6 Answers   IBM, Tanla Solutions,

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  

---

Can another user execute your local temporary stored procedures?

0 Answers  

---