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.

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

993

---

What is the difference between commit and rollback?

876

---

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

977

---

What are window functions in sql server?

937

---

How do I find the sql server database version?

939

---

How to download microsoft sql server 2005 express edition?

975

---

How to get a list of columns using the "sys.columns" view in ms sql server?

918

---

Can a table be created inside a trigger?

921

---

How to declare and use cursor variables?

1074

---

How many types of the database links?

1023

---

Write down the syntax and an example for create, rename and delete index?

924

---

How ssrs maintain security?

1016

---

What is the purpose of the tempdb database?

958

---

What is sql collation?

1137

---

What do you understand by coalesce in sql server?

1000

---