Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
photond
Starting Member
20 Posts |
 Posted - 2012-08-19 : 21:55:30
|
| I'm just starting out and trying to use Integration Services on my laptop at home. I currently have SQL Server 2012 and Visual Studio 2010 installed. When I go to Microsoft SQL Server 2012 > SQL Server Data Tools it wont' let me start an Integration Services Project. I've been able to do Analysis Services Projects but not integration services.It says:"Microsoft Visual Studio is unable to load this document. To design Integration Services packages in SQL Server Data Tools (SSDT), SSDT has to be installed by one of these editions of SQL Server 2012: Standard. Enterprise. Developer, or Evaluation. To install SSDT, run SQL Server Setup and select SQL Server Data Tools."Do I have to purchase something extra for that? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-19 : 22:02:02
|
| whats the edition of sql server 2012 you've installed?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
photond
Starting Member
20 Posts |
Posted - 2012-08-20 : 20:46:02
|
| I have the SQL Server Express Edition, I guess that's my problem? Can I get the necessary software to run SSIS for free or cheaply? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-20 : 20:50:48
|
| yep...SSIS is only available from standard edition. You will not be able to use Integration services in express edition------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
photond
Starting Member
20 Posts |
Posted - 2012-08-21 : 08:54:25
|
| Thanks. I downloaded the file for the full trial version and I was unable to complete the installation because it ran into an error.Will I be able to download it and install it on top of my current SQL Server Express edition? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-21 : 10:18:59
|
quote:
Originally posted by photond
Thanks. I downloaded the file for the full trial version and I was unable to complete the installation because it ran into an error.Will I be able to download it and install it on top of my current SQL Server Express edition?
yep..you can install it as a different named instance so that they'll co existor if dont want both, you can uninstall current express and install the newly downloaded one as the default instance------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Problems starting Integration Services project