Answer / samba shiva reddy . m

Data Transformation Services (DTS), introduced in SQL Server 7.0 and further improved in SQL Server 2000 drastically changed this situation.

We will create the DTS packages mainly for importing and exporting data into data bases.
Importing Problems :
when we importing excel data to Database if the columns in the table and columns in the excel are not same it will give the problem
columns data type miss match.
If first row as Null in Excel it will take all rows as nulls in that column
Maping of the columns.
If Excel contains some rows as number and some rows as columns it may take all rows as nulls.
If we deleted some rows in the last of excel it will import those rows as nulls.
If we importing Date Time columns we have to make sure those are in the correct format.
Exporting Problems
Connection problem
Data type problems
Tab delimitation problem when we export to text document.

how to implement locking in sql server

3 Answers   Satyam,

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

0 Answers  

---

What is Full Outer Join?

3 Answers  

---

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

0 Answers  

---

Explain filestream storage of sql server 2008?

0 Answers  

---

What is the purpose of forms?

0 Answers  

---

How to execute function in stored procedure sql server?

0 Answers  

---

What is tabulation?

0 Answers  

---

What does the on update no action do?

0 Answers  

---

Define Foreign Key?

3 Answers   ADP, College School Exams Tests,

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,

---