Post reply

Passing Sql server name as a parameter in SSIS

  • October 5, 2007 at 4:33 am

    #118463

    Is there any way to pass a Sql server Name as a parameter in SSIS - SQL server

  • October 5, 2007 at 4:42 am

    #739450

    Hi,

    Could you be more specific about your question? You could certainly use the system variable System::MachineName. But I would need to know where (i.e. what task(s)) you need to pass it to...

    Regards,

    Gogula

    (http://sqlserveruniverse.com)

  • October 7, 2007 at 8:59 pm

    #739871

    Please watch your forums. This was in the SQL 2000, General area. It has been moved.

  • October 8, 2007 at 6:34 am

    #739965

    You can set the ServerName property of a connection manager in a package configuration, which can come from an XML file, registry setting, environment variable, parent package variable, or SQL table.

    You can also create a package variable containing the server name, and add an expression on the configuration manager to set the ServerName property from the variable. The variable value can be set in a package configuration, by a dtexec command line parameter, or by other operations within the same package.

  • October 13, 2007 at 12:50 am

    #741778

    Thanks for all your replies.

    Thanks,

    ManoKarnan

Viewing 5 posts - 1 through 4 (of 4 total)

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