sql server - BIDS Package runs in BIDS but not at command line -



sql server - BIDS Package runs in BIDS but not at command line -

i made dtsx bundle moves info 1 database another. when run in bids runs fine. when run command line me runs fine. when run @ command line service business relationship created it, error source db's local sql server user\password incorrect. can't true, since username , password source db's local user embedded in project.

i tried giving domain/service business relationship db admin permissions, total server admin permissions. didn't anything. tried giving local business relationship ld_transfer001 more permissions, didn't anything. way i've been able work running domain admin business relationship @ command line. have verified folder packages live has right permissions.

running domain/service:

sql log:

login failed user 'ld_transfer001'. reason: password did not match login provided. [client: <local machine>]

command line error message:

microsoft (r) sql server execute bundle utility version 10.50.4000.0 64-bit copyright (c) microsoft corporation 2010. rights reserved. started: 9:47:57 error: 2014-10-15 09:47:57.74 code: 0xc0016016 source: description: failed decrypt protected xml node "dts:password" error 0 x8009000b "key not valid utilize in specified state.". may not authorized access information. error occurs when there cryptographic err or. verify right key available. end error error: 2014-10-15 09:47:57.76 code: 0xc0016016 source: description: failed decrypt protected xml node "dts:password" error 0 x8009000b "key not valid utilize in specified state.". may not authorized access information. error occurs when there cryptographic err or. verify right key available. end error progress: 2014-10-15 09:47:57.88 source: info flow task validating: 0% finish end progress error: 2014-10-15 09:47:57.92 code: 0xc0202009 source: franchiseeinfo connection manager "ldhqsql.001" description: ssis error code dts_e_oledberror. ole db error has occurred. error code: 0x80040e4d. ole db record available. source: "microsoft sql server native client 10.0 " hresult: 0x80040e4d description: "login failed user 'ld_transfer001'.". end error error: 2014-10-15 09:47:57.92 code: 0xc020801c source: info flow task ole db source [1] description: ssis error code dts_e_cannotacquireconnectionfromconnectionmanag er. acquireconnection method phone call connection manager "ldhqsql.001" f ailed error code 0xc0202009. there may error messages posted before thi s more info on why acquireconnection method phone call failed. end error error: 2014-10-15 09:47:57.92 code: 0xc0047017 source: info flow task ssis.pipeline description: component "ole db source" (1) failed validation , returned err or code 0xc020801c. end error progress: 2014-10-15 09:47:57.93 source: info flow task validating: 50% finish end progress error: 2014-10-15 09:47:57.93 code: 0xc004700c source: info flow task ssis.pipeline description: 1 or more component failed validation. end error error: 2014-10-15 09:47:57.93 code: 0xc0024107 source: info flow task description: there errors during task validation. end error dtexec: bundle execution returned dtser_failure (1). started: 9:47:57 finished: 9:47:57 elapsed: 0.266 seconds

running me[open command prompt normally no command line error message

login succeeded user 'ld_transfer001'. connection made using sql server authentication. [client: <local machine>]

sensitive info (i.e. password) encrypted in package. encryption key generated user business relationship of machine bundle developed.

therefore when running via service, decryption key not available , password cannot read , used.

there couple of options available resolve:

use windows authentication in connections in package.

use configuration file set connectionstring. check connection string in config file has plaintext password.

set protectionlevel property of bundle either encryptsensitivewithpassword or encryptallwithpassword , provide password dtsexec.

method 1 simplest, not appropriate.

method 2 nice workaround, leaves password in plaintext. tend opt method location our dts packages secure , have reconfigure stuff. config files!

method 3 sound solution too. have read here more information: http://msdn.microsoft.com/en-us/library/ms138023.aspx. need pass password using /decrypt alternative of dtsexec

sql-server ssis bids

Comments

Post a Comment

Popular posts from this blog

Delphi change the assembly code of a running process -

Delphi change the assembly code of a running process - i'm trying alter address 00741fa5 has push test.009e721c . alter push test.009e71c8 . procedure callback; asm force $9e71c8 end; procedure tform2.btn1click(sender: tobject); var ppid :dword; pprocess : cardinal; begin getwindowthreadprocessid(findwindow(nil,pchar('test')), @ppid); pprocess := openprocess(process_all_access, false, ppid); injectasm(pprocess, $741fa5, 10, integer(@callback), 0); end; here injectasm function (with error checking) function injectasm(process: longword; injectaddress, injectsize, codeaddress, codesize : integer): pointer; var csize, rsize : integer; replaced : array of byte; jmp : array [0..4] of byte; jmpaddress : integer; nopv : byte; : integer; nbr: ulong_ptr; begin //injectsize must equal or greater 5, because need space our //(far) jmp wwxxyyzz instruction //if there's no space, inject in place of few instructions if injectsize ...
Read more

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) -

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) - hello have problem hibernate , jackson. have 2 pojos @entity @table(name = "users") public class user implements serializable { static final long serialversionuid = 4235637833262722256l; @id @generatedvalue private int id; @column(name = "creation_date") private date creationdate; @column(name = "first_name") private string firstname; @column(name = "last_name") private string lastname; @version @column(name = "version") private int version; @column(name = "e_mail") private string email; @column(name = "enabled") private boolean enabled; @column(name = "login") private string login; @column(name = "password") private string password; @jsonmanagedreference("role") @onetomany(mappedby = "user", cascade = cascadetype.all,fetch = fetchtyp...
Read more

C++ 11 "class" keyword -

C++ 11 "class" keyword - i've started using c++ 11 little bit more , have few questions on special uses of class keyword. know it's used declare class, there's 2 instances have seen don't understand: method<class t>(); and class class_name *var; why precede typename keyword class in first example, , keyword pointer in sec example? that known elaborated type specifier , necessary when class name "shadowed" or "hidden" , need explicit. class t { }; // love of god don't t t; t t2; if compiler smart, give these warnings: main.cpp:15:5: error: must utilize 'class' tag refer type 't' in scope t t2; ^ class main.cpp:14:7: note: class 't' hidden non-type declaration of 't' here t t; ^ if class not defined, deed forwards declaration. for example: template <typename t> void method() { using type = typename t::value_type; } method...
Read more