Get Data Moving 1
Results 1 to 5 of 5

Thread: SSIS connection String with expression

  1. #1
    fantasimus is offline Junior Member
    Join Date
    Nov 2012
    Posts
    3
    Rep Power
    0

    SSIS connection String with expression

    Hi,

    i have a couple of teradata data sources which. The connections strings are saved in a table.
    on runtime the will be loaded and set to the expression settings of the connection in the connection manager.

    The password, which is inclueded in the loaded connectionstring from the DB to the expression, isnīt be set.
    the packages always uses the password which is saved in the password property.

    anybody an idea ?

    thank you

  2. #2
    smeeluv is offline Junior Member
    Join Date
    Nov 2012
    Posts
    11
    Rep Power
    0
    Do the connection strings in the table have the password added to them? If not, you have to update them with the password=***.

  3. #3
    fantasimus is offline Junior Member
    Join Date
    Nov 2012
    Posts
    3
    Rep Power
    0
    Quote Originally Posted by smeeluv View Post
    Do the connection strings in the table have the password added to them? If not, you have to update them with the password=***.
    Yes, the password in the connectionstring included.

    In my opinion the password is ignored in he connectionstring and will not be set in the password property.
    I hope i am wrong

  4. #4
    fantasimus is offline Junior Member
    Join Date
    Nov 2012
    Posts
    3
    Rep Power
    0
    i solved it: the password in the connectionstring is PWD= and not password

    so, if you use the connectionstring for the teradata source use this:

    DRIVER={Teradata};CHARSET=UTF8;LOGINTIMEOUT=20;DBC NAME=<SERVER>;UID=<USERID>;DATABASE=<DATABASE>;PWD =<PASSWORD>;ACCOUNT=;AUTHENTICATION=;WINAUTH=0

  5. #5
    smeeluv is offline Junior Member
    Join Date
    Nov 2012
    Posts
    11
    Rep Power
    0
    Sorry, I forgot this was the Attunity connector. For the standard OLE DB you have to add "password" to it. With the Attunity, yes, "pwd" is correct.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •