1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Can you explain some of the DTS problems?

Question Posted / vamsimadineni


Can you explain some of the DTS problems?..

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.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,

what is sql injection?

2 Answers  

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

0 Answers  

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

0 Answers  

How to use the inserted and deleted pseudo tables?

0 Answers  




What is conditional split?

0 Answers  

How connect excel to sql server?

0 Answers  

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 Answers   Credit Suisse, GCU, Symphony, TCS,

What is the server name for sql management studio?

0 Answers  

What is default constraint?

0 Answers  

what are the different ways to return the rowcount of a table?

0 Answers   Microsoft,

How will you monitor replication latency in transactional replication? : sql server replication

0 Answers  

For more SQL Server Interview Questions Click Here
Categories