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 are the different types of sub-queries?
What language is sql server written in?
what is a schema in sql server 2005? : Sql server database administration
Why do you want to join software field as you have done your BE in Electronics?
How do you debug a procedure in sql server?
How do I run a trace in sql server?
How do I uninstall sql server 2014?
What are policy management terms?
How to delete duplicate rows in sql server?
query processing
what is a transaction? : Sql server database administration
what is a check constraint?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What are trace files?
how many layers of tcp/ip protocol combined of? : Sql server database administration