471,072 Members | 1,243 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,072 software developers and data experts.

Making Inegration Services visible/available in SSMS 2005

I have installed SQL Server Management Studio 2005 and have been
finding the equivalent of the Data Transfer Services in SQLServer
2000. I think I have worked out that it is in SQL Server Integration
Services but when I open File-New-Project I do not see the SQL Server
Integration Services there, though Help assumes that it is available
for selection when starting a new project..

How can I make it visible in the New Project window?

I have successfully used the import function so I think this means
that Inegration Services is there somewhere.

I would appreciate some advice,

Best wishes, John Morgan
Jan 28 '07 #1
3 1653
John Morgan wrote:
I have installed SQL Server Management Studio 2005 and have been
finding the equivalent of the Data Transfer Services in SQLServer
2000. I think I have worked out that it is in SQL Server Integration
Services but when I open File-New-Project I do not see the SQL Server
Integration Services there, though Help assumes that it is available
for selection when starting a new project..

How can I make it visible in the New Project window?

I have successfully used the import function so I think this means
that Inegration Services is there somewhere.

I would appreciate some advice,

Best wishes, John Morgan
What version of 2005 are you using?
Jan 28 '07 #2
John Morgan (jf*@XXwoodlander.co.uk) writes:
I have installed SQL Server Management Studio 2005 and have been
finding the equivalent of the Data Transfer Services in SQLServer
2000. I think I have worked out that it is in SQL Server Integration
Services but when I open File-New-Project I do not see the SQL Server
Integration Services there, though Help assumes that it is available
for selection when starting a new project..

How can I make it visible in the New Project window?

I have successfully used the import function so I think this means
that Inegration Services is there somewhere.
I believe the place to work with Integrations Services is the
Business Intelligence Development Studio.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jan 28 '07 #3
Thanks both of you. Using your info and investigating the matter
further to make sure I don't hask silly questions has got me the
answer.

I checked the configuration manager and found that integrated services
was listed as running, I looked again and, yes, I did see SQL
Buisiness iIntelligence Studio was part of the programme group.

Opened it up and the VStudio installed templates for Integration
Services Project were visible.

Thanks
John Morgan

On Sun, 28 Jan 2007 08:24:28 -0600, Jonathan Roberts
<gr*******@diynics.comwrote:
>John Morgan wrote:
>I have installed SQL Server Management Studio 2005 and have been
finding the equivalent of the Data Transfer Services in SQLServer
2000. I think I have worked out that it is in SQL Server Integration
Services but when I open File-New-Project I do not see the SQL Server
Integration Services there, though Help assumes that it is available
for selection when starting a new project..

How can I make it visible in the New Project window?

I have successfully used the import function so I think this means
that Inegration Services is there somewhere.

I would appreciate some advice,

Best wishes, John Morgan

What version of 2005 are you using?
Jan 28 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Larry Bertolini | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.