Post reply

Need dtsConfig sample w/ UserID and Password for Package Variable connection

  • April 3, 2009 at 6:53 am

    #130350

    I'm using PACKAGE VARIABLES to dynamically set my OLE DB Conn Manager connections ServerName & DBName. The ssis pkg runs fine w/ this dtsConfig file entry "IF" I connect w/ Windows Authentication.

    Now I'm at a client site and can ONLY use SQL Authentication to connect. I have the sa pwd...

    How can I construct the above dtsConfig entry to include UserID=sa, Password=MyPassword ?

    If possible, please construct the above XML integrating the UserID and Password into it.

    thanks in advance

    BT

  • April 3, 2009 at 6:56 am

    #971490

    My XML did not show in last post.. so Ill break it apart.... to allow for posting:

    Configuration ConfiguredType = "Property" Path=" \Package.Variables[User::MyVariableName].Properties[Value]" ValueType="String"

    ConfiguredValue>MyServerName / ConfiguredValue

    / Configuration

    BT

  • April 8, 2009 at 7:03 am

    #974238

    DBASkippack (4/3/2009)

    I'm using PACKAGE VARIABLES to dynamically set my OLE DB Conn Manager connections ServerName & DBName. The ssis pkg runs fine w/ this dtsConfig file entry "IF" I connect w/ Windows Authentication.

    Now I'm at a client site and can ONLY use SQL Authentication to connect. I have the sa pwd...

    How can I construct the above dtsConfig entry to include UserID=sa, Password=MyPassword ?

    If possible, please construct the above XML integrating the UserID and Password into it.

    thanks in advance

    Try specifying user name and password in your ConnectionString property.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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