Getting the SSIS package store to work with a SQL Server named instance

We have a named SQL instance and I am able to connect to the instance, but when I try to view the SSIS packages stored in the MSDB database I get an error. This does not happen with our default instances. Is there an additional setting that must be changed to get this to work?

Container Tasks in SQL Server 2008 Integration Services

Learn how container control flow tasks within SSIS can be used by database developers to provide a structure to a package and repeat control flows.

Using the Script Component With Multiple Outputs

This article demonstrates the use of the SSIS Script Component to create multiple outputs from unconventional data files.

Container Tasks in SQL Server 2008 Integration Services

Learn how container control flow tasks within SSIS can be used by database developers to provide a structure to a package and repeat control flows.

SSIS File Exists Over Range of Time

The process to use a vb script task to check for a file existence over a time range.

SSIS Package store

SSIS Custom Error Handling

This article from Zach Mattson shows how you can set up custom error handling in your SSIS packages. Learn how to direct those error rows to another component for separate processing.

Using Event Handlers with Checkpoints (Part 3)

In Part 3 of his series on checkpoints in SSIS, Aaron Akin talks about how you can use event handlers in your containers to better control the workflow.

Roll Your Own SSIS Fuzzy Matching / Grouping (Jaro - Winkler)

Roll Your Own SSIS Fuzzy Matching / Grouping (Jaro - Winkler)

Creating packages in code - Flat File Source to OLE-DB Destination

This code sample programmatically creates a package that imports a text file into SQL Server, with a Flat File Source and the OLE-DB Destination. This shows how you can leverage the SSIS engine to write your own data import tool for example, but beware importing files is not as simple as it may seem