Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

In the Visual Studio designer you can right click on a SSIS package and designate it as an "Entry Point" package"

Screen shot of Visual Studio designer

Doing a search I found this page on MSDN which states:

The value of 1 signifies that the package is meant to be started directly. The value of 0 signifies that the package is meant to be started by another package with the Execute Package task. The default value is 1.

With this flag enabled and disabled I have been able to execute a package directly.

What is the purpose of enabling or disabling this flag? Is it merely to document the intentions of your own SSIS packages or does SQL Server/SSIS behave differently when it enabled or disabled?

share|improve this question

2 Answers 2

up vote 5 down vote accepted

There's one behaviour I can think of:

Only packages with "Entry Point Package" set to 1 can be executed by catalog.create_execution

(see http://msdn.microsoft.com/en-us/library/ff878034.aspx)

share|improve this answer

On a side note:

The default scope on the parameters configuration page in the Integration Services Catalogs is called "Entry-point packages and project".

You will probably want to disable this flag on child packages so that their parameters doesn't show up and clutter the configuration dialog.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.