Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How can we do ETL process in SQL Server?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is the limit to the number of sources and targets you can have in a mapping?

999


What is the main difference between star and snowflake star schema? Which one is better and why?

1035


What is the difference between snowflake and star schema?

1048


What is a general purpose scheduling tool?

1109


Explain if a flat file cotains 1000 records how can I get first and last records only?

931


hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

2050


In microstrategy, how can we direct the sql generated to use a specifc table?

1032


Can decision tree be implemented using SQL?

2119


What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

1100


Explain what are components of report studio?

1103


How to design file watch jobs?

970


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

947


What is the goal of optimizer?

1049


Is there any rownum object from which we can do this?

943


What are the different problems that ?Data mining? can solve?

2824