Creating SSIS packages in VS2010 for SQL Server 2008r2


I just want to create new packages in VS2010(that's what was deployed with my machine). However, I dodn't see the option to add an SSIS Integration pacakge. I see alot of database options, but no way to add an SSIS package.

Is this even possible ?
Auerelio VasquezETL DeveloperAsked:
Who is Participating?
Shaun KlineConnect With a Mentor Lead Software EngineerCommented:
Though the SQL Server client tools use the Visual Studio IDE, the Project/Solution type is only available if you install the SQL Server tools found in the SQL Server installer for your version (2008). The good news is that you can use any flavor of the SQL Server installer to get the SQL Server client tools. For SQL Server 2008, it uses the Visual Studio 2008 IDE, which can be installed separately from the 2010 version. You may, however, have to install the 2008 version prior to the 2010 version.
Auerelio VasquezETL DeveloperAuthor Commented:
So, since they have already installed VS2010, do i have to have it uninstalled ? Then start over? it seemed like the version of SQL Server they installed didn't include BIDS. IS that not standard ?
Shaun KlineLead Software EngineerCommented:
I do not know for sure if they need to uninstall 2010. BIDS is a separate option in the installer.
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Not sure about 2010, but the separate download for the Visual Studio 2012 BI tools is here.

Good luck.
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.