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 what are the modules in power mart?

971

How can we schedule the graph in unix?

934

What is dimensional modelling?

930

Explain what are components of report studio?

1024

Explain what is the difference between powerplay transformer and power play reports?

1069

What is a real-time data warehouse?

945

How can you communicate with web server (apache or iis) from coldfusion?

1034

Explain the difference between keylokup and joiner?

842

I need a good brd and uc template?

1031

Explain how to generate iqd file from framework manager?

901

What are the different models used in cluster analysis?

897

What is the function of surrogate key in data warehousing?

997

What according to you might be the future of data warehousing?

939

List down some of the real time data-warehousing tools?

914

Explain why fact table is in normal form?

918