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

Issues related in upgrading SQL Server 2000 to 2005 / 2008

0 Answers  

Write a SQL query in order to merge two different columns into single column?

0 Answers   QuestPond,

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 Answers  

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

3 Answers   247Customer,

explain different types of jions with examples briefly?

1 Answers   Zensar,

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

Do you know what are pages and extents? : SQL Server Architecture

0 Answers  

What are null values in ms sql server?

0 Answers  

What triggers long term care?

0 Answers  

WHAT OPERATOR PERFORMS PATTERN MATCHING?

2 Answers   CarrizalSoft Technologies, CTS,

Explain the new features of SQL server 2000?

1 Answers  

What command do we use to rename a db, a table and a column?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories