Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

What is the difference between constraints and triggers?

9 Answers   Wipro,

i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...

2 Answers  

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

0 Answers  

What is sql injection? How to protect against sql injection attack?

0 Answers  

How to create a new table in a given schema?

0 Answers  

Describe how to use linked server?

0 Answers  

What is the difference between UNION and UNIONALL?

5 Answers   CarrizalSoft Technologies, CTS,

How to disconnect from a sql server using mssql_close()?

0 Answers  

What are the diifferences between the ms sql server vs mysql?

0 Answers  

What are the advantages of using third-party tools?

0 Answers  

Which trace flags are enabled in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories