Interested to Buy Any Domain ? << Click Here >> for more details...
Can you explain some of the DTS problems?
- 1 Answers
- 4890 Views
- UBS, Wipro, I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a user-defined function in the sql server and what is its advantage?
Explain the benefits of user-defined functions?
What is Dependency Injection and provide example?
What is difference between drop truncate and delete?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
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 ?
What is an etl file?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Do you know what are the restrictions that views have to follow?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What is the optimization being performed in oracle and SQL Server?
Is port 1433 secure?
How many triggers you can have on a table?
What is a rownum?
What is shared lock?
