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
 General SQL Server Forums
 New to SQL Server Programming
 Need ti install SSI pakge
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Pasi
Posting Yak Master

150 Posts

Posted - 05/05/2014 :  12:01:40  Show Profile  Reply with Quote
HI All,

I am running SQL version 11.02 and I do not see SSI on my menu. I tried looking for it in Menu items but I am not sure how you can enable this so I can start using it? Any help would be great!
Thanks.

Lamprey
Flowing Fount of Yak Knowledge

4614 Posts

Posted - 05/05/2014 :  12:08:18  Show Profile  Reply with Quote
If you want to create SSIS packages then you need to use Visual Studio. More specifically, the SQL Server Data Tools (SSDT) or SSDT-BI, depending:
http://msdn.microsoft.com/en-us/data/tools.aspx
Go to Top of Page

Pasi
Posting Yak Master

150 Posts

Posted - 05/05/2014 :  12:20:36  Show Profile  Reply with Quote
I have Visual studio 2012 and when I look and try ti add SSI pckg to menu its grayed out?
Pasi.
Go to Top of Page

Lamprey
Flowing Fount of Yak Knowledge

4614 Posts

Posted - 05/05/2014 :  12:33:46  Show Profile  Reply with Quote
In VS 2012

Create a new Project:
File -> New -> Project

Then on the New Project dialog, navigate to Installed -> Tempaltes -> Business Intelligence and Select Integration Services. That should create a new SSIS project for you. If you don't have that option then you need to install SSDT (Or SSDT-BI? I forget) for VS2012.
Go to Top of Page

Pasi
Posting Yak Master

150 Posts

Posted - 05/05/2014 :  12:58:20  Show Profile  Reply with Quote
Thanks you, I see under installed templates only SQL management studio solution and Project . I don't have the Business Intelligence. I probablay have to install the SSD.
Go to Top of Page

Pasi
Posting Yak Master

150 Posts

Posted - 05/05/2014 :  13:25:33  Show Profile  Reply with Quote
Lamprey,

I installed the SSD pckge for buiss intelligence but still grayed out?
any idea? whne I go to the New Project dialog, navigate to Installed -> Tempaltes -> Business Intelligence and Select Integration Services, I don't see the Business Intelligence?

Thanks.

quote:
Originally posted by Lamprey

In VS 2012

Create a new Project:
File -> New -> Project

Then on the New Project dialog, navigate to Installed -> Tempaltes -> Business Intelligence and Select Integration Services. That should create a new SSIS project for you. If you don't have that option then you need to install SSDT (Or SSDT-BI? I forget) for VS2012.

Go to Top of Page

Lamprey
Flowing Fount of Yak Knowledge

4614 Posts

Posted - 05/05/2014 :  13:37:15  Show Profile  Reply with Quote
Sorry, I don't know. If you are not using Visual Studio Professional or above you can try launching the VS shell that SSDT installs instead.
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.11 seconds. Powered By: Snitz Forums 2000