Where is SSIS?

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.


purplesoupAsked:
Who is Participating?
 
lcohanDatabase AnalystCommented:
Ok so start your VS, go to File menu and say new then select "Integration Services Project" and go from there.
0
 
PedroCGDCommented:
Go to control panel, goto to SERVICES and search for SQL Server Integration Services... Is it there?
Regards,
Pedro
0
 
lcohanDatabase AnalystCommented:
Any SQL IMPORT/EXPORT database task you will perform from SQL 2008 SSMS is using SSIS
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
EvilPostItCommented:
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.
0
 
purplesoupAuthor Commented:
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

http://www.sqlshare.com/showitem.aspx?id=44D341A4-A57F-4ADB-B011-9C7D4C0CC729

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.
0
 
EvilPostItCommented:
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.

0
 
PedroCGDCommented:
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...
0
 
purplesoupAuthor Commented:
Thanks for all your help - I'm up and running now
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.