SolvedPrivate

Creating SSIS packages in VS2010 for SQL Server 2008r2

Posted on 2014-09-10
4
41 Views
Last Modified: 2016-02-11
Hi,

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 ?
0
Comment
Question by:Auerelio Vasquez
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 26

Accepted Solution

by:
Shaun Kline earned 500 total points
ID: 40314473
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.
0
 
LVL 1

Author Comment

by:Auerelio Vasquez
ID: 40314486
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 ?
0
 
LVL 26

Expert Comment

by:Shaun Kline
ID: 40315385
I do not know for sure if they need to uninstall 2010. BIDS is a separate option in the installer.
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 40315473
Not sure about 2010, but the separate download for the Visual Studio 2012 BI tools is here.

Good luck.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Select Query help 1 47
MSSQL Convert Char to Date Time 5 33
MSSQL 2008 R2  Check to see if a Index/Key Exist 7 24
I am new to using JSON in SQL Server 2 56
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

739 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