Post reply

SQL Job using SSIS package with parameters

  • December 10, 2013 at 9:52 am

    #287347

    Hi all

    I have read so many threads on this but still seek a definitive answer...

    I am trying to pass a parameter in using /SET "\"\package.Variables[Parm1].Value\"";xyz

    I can use a package variable and it works fine, so I'm struggling to understand the benefits or purpose of the parameter option. I'd love to know.

    Thanks

    Executed as user: FRED. Microsoft (R) SQL Server Execute Package Utility

    Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved.

    Started: 16:24:14 Error: 2013-12-10 16:24:14.49

    Code: 0xC001F016

    Source: Parameters

    Description: Changing the Value of a variable failed because it is a parameter variable. Parameter variables are read-only. End Error DTExec: Could not set \package.Variables[Parm1].Value value to xyz.

    Started: 16:24:14 Finished: 16:24:14 Elapsed: 0.172 seconds.

    The package execution failed. The step failed.

  • December 12, 2013 at 6:19 am

    #1672924

    Adrian_1 (12/10/2013)

    Hi all

    I have read so many threads on this but still seek a definitive answer...

    I am trying to pass a parameter in using /SET "\"\package.Variables[Parm1].Value\"";xyz

    I can use a package variable and it works fine, so I'm struggling to understand the benefits or purpose of the parameter option. I'd love to know.

    Thanks

    Executed as user: FRED. Microsoft (R) SQL Server Execute Package Utility

    Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved.

    Started: 16:24:14 Error: 2013-12-10 16:24:14.49

    Code: 0xC001F016

    Source: Parameters

    Description: Changing the Value of a variable failed because it is a parameter variable. Parameter variables are read-only. End Error DTExec: Could not set \package.Variables[Parm1].Value value to xyz.

    Started: 16:24:14 Finished: 16:24:14 Elapsed: 0.172 seconds.

    The package execution failed. The step failed.

    Parameters can be set using the environments option in the SSISDB catalog. As the error states they are read only but can be controlled at the execution of the package using environments.

    They cannot be changed during execution like variables.

    This forum post from another site has a detailed explanation:

    http://stackoverflow.com/questions/15206184/how-to-configure-ssis-2012-project-to-run-under-different-environment-configurat

    MCITP SQL 2005, MCSA SQL 2012

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply