How to work on DTS?what is the main requirement?
Answer / 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 |
What is the contrast amongst drop and truncate?
Tell me about builtinadministrator?
What is the difference between coalesce() & isnull()?
What are alternate keys?
how would you troubleshoot blocking? : Sql server database administration
I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?
How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com
35 Answers Oracle, Scend, TechInfini,
How to generate random numbers with the rand() function in ms sql server?
Tell me what is de-normalization and what are some of the examples of it?
How to disable triggers using "disable trigger"?
Can you explain different types of joins?
How to use go command in "sqlcmd"?