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
 Cannot view the "Storage Packages" folder
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

steph
Starting Member

2 Posts

Posted - 04/11/2007 :  14:20:59  Show Profile  Reply with Quote
Hi folks,

I've been learning how to build an ETL package in MS SQL 2005 using the MSDN turorials. I wanted to deploy the package and followed the procedures (Created a deployment bundle) and then ran the package install wizard. I am now stuck as I cannot view the installed packages thru MS SQL Server Management Studio and obviously cannot use them. I should be able to see a "Storage Packages" folder in the "Object Explorer" window but it isn't available. Any idea why I cannot see this folder ? I know my packages are installed as I can see them in the system table called "dbo.sysdtspackages90". The " Integration Services" service is also started. Not sure what else I can check.

Thanks,

Steph

Edited by - steph on 04/11/2007 14:22:53

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 04/11/2007 :  14:22:39  Show Profile  Visit tkizer's Homepage  Reply with Quote
You need to view them through Business Intelligence Development Studio and not through Management Studio.

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

steph
Starting Member

2 Posts

Posted - 04/11/2007 :  14:48:20  Show Profile  Reply with Quote
quote:
Originally posted by tkizer

You need to view them through Business Intelligence Development Studio and not through Management Studio.

Tara Kizer
http://weblogs.sqlteam.com/tarad/



Thanks but I think its really odd that this cannot be done thru Management Studio. Please have a look at the following link:

http://msdn2.microsoft.com/en-us/library/ms365323.aspx

To also avoid confusion, I dont want to view or edit an existing ETL package but instead view the package I deployed on the server.

Thanks,

Steph

Edited by - steph on 04/11/2007 14:54:22
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