Interested to Buy Any Domain ? << Click Here >> for more details...
Can you explain some of the DTS problems?
- 1 Answers
- 4817 Views
- UBS, Wipro, I also Faced
- E-Mail Answers
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 |
What is a sql join?
What is the difference between char and varchar2 datatype in sql?
What is the purpose of using COLLATE in a query?
What are the benefits and tasks of object explorer? : sql server management studio
What are the approximate numeric data types?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
Can you leave a union at any time?
How to perform backup for certificates in sql server? : sql server security
How to insert data with null values?
There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.
What are the default system databases in sql server 2000?
Explain about remote stored procedure?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
