How to start with SQL Server SSIS? [closed]

Closed. This question needs to be more focused. It is not currently accepting answers.

---

Want to improve this question? Update the question so it focuses on one problem only by editing this post.

Closed 7 years ago.

Improve this question 开发者_运维技巧

I want to start with SQL Server SSIS. Kindly guide how to start with it and what are the areas that need to be looked in first.

---

Before diving in and getting your hands dirty start with the basic theory first. You want to be able to provide an answer to the questions "What is SSIS and what is it used for?"

My advice, start at the beginning, read the Microsoft supporting documentation for SQL Server Integration Services and develop an overall understanding of the technology and its features.

Another good place to start would be the Getting Started (Integration Services)

Then why not have a go at some of the Tutorials that Microsoft make available.

---

Suggest you type 'SQL Server SSIS Tutorial' into google, or follow this link

http://www.google.co.uk/search?hl=en&q=sql+server+ssis+tutorial&aq=f&aqi=g10&aql=&oq=&gs_rfai=

Top result is http://www.accelebrate.com/sql_training/ssis_tutorial.htm

Alernatively, document exactly what it is you want to do, and then see if you can find something to help you.

I assunme you have SQL Server installed. At the very start, click Start Menu -> Programs -> Microsoft SQL Server 2005 -> SQL Server Business Intelligence Development Studio.

From in Business Intelligence Development Studio (BIDS) you will be able to create a new SSIS project.

---

Searching Google (or Bing) for "SSIS tutorial" would yield lots of results.....

E.g.

• SSIS Tutorial: SQL Server 2005 Integration Services Tutorial
• SQL Server Integration Services (SSIS) (Introduction)
• SSIS Tutorials - Introduction to SSIS Tasks

and many, many more...