Where is SSIS?

Posted on 2011-02-15
Last Modified: 2012-05-11
I have SQL Server 2008 installed - I'm not sure what version, probably developer edition.

I can't see SSIS installed anywhere - I have SQL Server Business Intelligence Development Studio, SSMS and various other tools (profiler etc). I can't see it in the programs list anyway.

I also have VS 2008 installed.

Do I have SSIS, if not how do I get it?

This is on my development machine - it is Windows 7 64 bit.

Question by:purplesoup
  • 2
  • 2
  • 2
  • +1
LVL 22

Expert Comment

ID: 34897618
Go to control panel, goto to SERVICES and search for SQL Server Integration Services... Is it there?
LVL 39

Expert Comment

ID: 34897655
Any SQL IMPORT/EXPORT database task you will perform from SQL 2008 SSMS is using SSIS
LVL 16

Expert Comment

ID: 34897770
As per PedroCGD's comment. "SQL Server Integration Services" will be underneath the services window if it is installed. If not you will need to re-run the installation and select SSIS.

Author Comment

ID: 34897843
ok I do have SQL Server Integration Services 10.0 in services.

I do have an import and export data entry, but this is just a wizard.

I asked the question because I just watched a video from SQL Share

and would like to try using SSIS. In the video it shows an SSIS package within Visual Studio, where you drag and drop items (such as a data flow task) into the package - it is this I want to use.
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

LVL 39

Accepted Solution

lcohan earned 350 total points
ID: 34897866
Ok so start your VS, go to File menu and say new then select "Integration Services Project" and go from there.
LVL 16

Assisted Solution

EvilPostIt earned 100 total points
ID: 34897867
What you would have seen on SQLShare is just the development area which will work on any machine. SSIS in essense is just a service which runs packages with no real visual interface.

Once you have completed the package you would deploy it to a SQL Server or filesystem and use SSIS to execute the package.

LVL 22

Assisted Solution

PedroCGD earned 50 total points
ID: 34897888
You need to install the visual studio module for SSIS, SSAS and SSRS tools... This is BIDS Business Intelligence Development Studio.... You have this module with the SQL Server software...

Author Closing Comment

ID: 34898284
Thanks for all your help - I'm up and running now

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SQL Server 2012 Row Selection 2 31
IN with @variable 5 20
login and database user 3 22
SQL Query 2 0
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now