How to work on DTS?what is the main requirement?
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 use of attribute hierarchy optimized state? : sql server analysis services, ssas
How do you handle datasets larger than 50 gb?
Is the primary key column of a table an index in ms sql server?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
How do I create a trace in sql server?
Can sql server be linked with other servers like oracle?
What do you mean by the term 'normalization'?
How to see existing views in ms sql server?
What is replication and database mirroring?
What are the differences between union, intersect, and minus operators?
When you should use a low fill factor?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
What is xml datatype?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is the difference between Triggers and Stored Procedure?