September 25, 2006 at 10:12 pm
I performed an Export of some data to an Excel Spreadsheet and saved it as a SSIS Package.
Silly question I know but how do I view the package I just created in SQL Server Management Studio? Doesn't it get saved in the MSDB Database like it use to on SQL Server 2000 and then click on the DTS Packages folder to see all your packages? How do you do this in 2005?
September 27, 2006 at 9:03 am
You can use SSMS, but you must fist register your instance of Integration Services.
At the top right in SSMS, there is the box titled 'Registered Servers'. Instead of the database engine, you need to select 'Integration Servers'. Once this server is the object explorer, you can expand the tree to show the packages stored in msdb.
September 27, 2006 at 6:21 pm
Thanks for the reply.
I tried whta you said but I get the following error when I click on the MSDB folder.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
------------------------------
Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
------------------------------
BUTTONS:
OK
------------------------------
May 18, 2007 at 2:36 pm
I'm not sure if you ever got an answer to this. However, I recently ran across the same problem while using a named instance of SQL Server 2005. In this case, you have to manually adjust the configuration file for Integration Services.
Please note the following article: http://msdn2.microsoft.com/en-us/library/ms137789.aspx
Hope this helps!
Mike
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply