SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Problems starting Integration Services project		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

photond
Starting Member

9 Posts
Posted - 08/19/2012 :  21:55:30  Show Profile  Reply with Quote
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

India
47173 Posts
Posted - 08/19/2012 :  22:02:02  Show Profile  Reply with Quote
whats the edition of sql server 2012 you've installed?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

photond
Starting Member

9 Posts
Posted - 08/20/2012 :  20:46:02  Show Profile  Reply with Quote
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?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47173 Posts
Posted - 08/20/2012 :  20:50:48  Show Profile  Reply with Quote
yep...SSIS is only available from standard edition. You will not be able to use Integration services in express edition

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

photond
Starting Member

9 Posts
Posted - 08/21/2012 :  08:54:25  Show Profile  Reply with Quote
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?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47173 Posts
Posted - 08/21/2012 :  10:18:59  Show Profile  Reply with Quote
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 exist

or if dont want both, you can uninstall current express and install the newly downloaded one as the default instance

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000