Share via

Select a Package

Use the Select a Package dialog box to specify the package from which the Message Queue task can receive messages.

Static Options

  • Location
    Specify the ___location of the package. This property has the options listed in the following table.

    Value Description

    SQL Server

    Set the ___location to an instance of SQL Server. Selecting this value displays the dynamic options, Server, Use Windows Authentication, Use SQL Server Authentication, User name, and Password.

    DTSX file

    Set the ___location to a DTSX file. Selecting this value displays the dynamic option, File name.

Location Dynamic Options

Location = SQL Server

  • Package name
    Select a package that is stored on the specified server.
  • Server
    Provide a server name or select a server from the list.
  • Use Windows Authentication
    Click to use Windows Authentication.
  • Use SQL Server Authentication
    Click to use SQL Server Authentication.
  • User name
    If using SQL Server Authentication, provide a user name to use when logging on to the server.
  • Password
    If using SQL Server Authentication, provide a password.

Location = DTSX file

  • File name
    Provide the path of a package or click the browse button (…) and locate the package.

See Also

Reference

Other UI Reference

Other Resources

Message Queue Task

Help and Information

Getting SQL Server 2005 Assistance