Explain how dts is used to extract, transform and consolidate data?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How to disconnect from a sql server using mssql_close()?

0 Answers  


What are the differences between substr and charindex in sql server.

0 Answers  


What is set nocount on and what is set nocount off?

0 Answers  


Do you know what is a linked server in sql server?

0 Answers  


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

0 Answers  






How to copy the tables, schema and views from one sql server to another?

0 Answers  


What are rows and columns?

0 Answers  


How do I open port 1433?

0 Answers  


What is a livelock?

0 Answers  


you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

0 Answers  


How to create function with parameter in sql server?

0 Answers  


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

0 Answers  


Categories