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 can I create a table from another table without copying any values from the old table?

3 Answers  

---

How many types of local tables are there in sql server?

0 Answers  

---

syntax for deleting the database in T SQL

5 Answers  

---

How to select all columns of all rows from a table with a select statement in ms sql server?

0 Answers  

---

how to rename the table

3 Answers  

---

Explain the flow of creating a cube? : sql server analysis services, ssas

0 Answers  

---

What are primary keys and foreign keys?

4 Answers  

---

What is the command dbcc checkdb used for?

0 Answers  

---

how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?

1 Answers  

---

Explain tablesample?

0 Answers  

---

What are various aggregate functions that are available?

0 Answers  

---

What is a trigger?

7 Answers  

---