In Sql Server 2005 WE can use SSIS package from BIDS and can do ETL proce

How can we do ETL process in SQL Server?

Question Posted / nilanjana

Answer Posted / nilanjana

In Sql Server 2005 WE can use SSIS package from BIDS and
can do ETL process as per requirement. Earlier in Sql
server 2000 It was acheived by DTS.

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

904

What is the difference between static cache and dynamic cache?

993

Explain what are the possible data marts in retail sales?

1010

What are cluster analysis in data warehousing?

1108

Tell me what is degree of a relation?

997

Explain how are the dimension tables designed?

1060

Explain what is batch and describe about types of batches?

1080

What are various warehousing tools?

1004

What is recovering sessions?

938

Explain what are the advantages and disadvantages of reporting directly against the database?

1003

What are the main steps to build the data warehouse?

1119

What are the different types of join operations?

1002

What are aggregate tables and aggregate fact tables?

1040

Explain a relation schema and a relation?

1109

What is ods (operation data source)?

997