Need ti install SSI pakge - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Need ti install SSI pakge

Author

Topic

Pasi
Posting Yak Master

166 Posts

Posted - 2014-05-05 : 12:01:40

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
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2014-05-05 : 12:08:18

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

Pasi
Posting Yak Master

166 Posts

Posted - 2014-05-05 : 12:20:36

I have Visual studio 2012 and when I look and try ti add SSI pckg to menu its grayed out?
Pasi.

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2014-05-05 : 12:33:46

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.

Pasi
Posting Yak Master

166 Posts

Posted - 2014-05-05 : 12:58:20

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.

Pasi
Posting Yak Master

166 Posts

Posted - 2014-05-05 : 13:25:33

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.

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2014-05-05 : 13:37:15

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.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources