Interested to Buy Any Domain ? << Click Here >> for more details...
How to work on DTS?what is the main requirement?
- 1 Answers
- 5741 Views
- Getit, ivan, I also Faced
- E-Mail Answers
Answer Posted / naresh
DTS (Data Transformation Services) allows you to get stuff
in and out of SQL Server and between any ODBC and OLE DB
data source. That includes DB2, Access, Excel and Text, as
well as Oracle, MySQL, PostgresSQL and even SQLLite. -in
fact, anything with an ODBC driver. Not only does it do the
transfer but it allows you to fill in missing data, do
column mappings and so on. In other words, you can fiddle
with the data as it passes through.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is updatable resultset?
What is intellisense?
What are sparse columns?
What are group functions in query statements in ms sql server?
How you would rewrite the sql query to return the customerid sorted numerically?
What is indexed view? How to create it?
What is molap and its advantage? : sql server analysis services, ssas
What is reference section?
What is SubQuery in SQL Server 2008
How can we call UDF(User Define Function) using C# code in ASP.net ?
Is it ok to shrink transaction log?
How column data types are determined in a view?
How to query multiple tables jointly?
What are the different types of triggers in SQL SERVER?
What is primary key and example?
