Answer Posted / 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.

What is the difference between row_number and dense_rank?

881

---

your distribution database is full what will u do

2172

---

What are indexes in sql?

1281

---

How to create a stored procedure with a statement block in ms sql server?

1070

---

Give main differences between "Truncate" and "Delete".

1099

---

Explain the microsoft sql server delete command?

1024

---

How can we improve performance by using SQL Server profiler?

1055

---

Why are sql functions used?

1124

---

How to delete existing rows in a table?

1161

---

What are the different types of upgrades that can be performed in sql server?

1177

---

How to count duplicated values in a column in ms sql server?

1095

---

What is the usage of the sign function?

1114

---

What are the differences between clustered and non-clustered index?

1033

---

What is a view in sql?

977

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1386

---