sql - SSIS Package What credential SSIS is running? -

-

i have package access excel file .xls. file located on network path.
the packaged called store pass use32bitruntime = true. store called c# code.
if file local file => package run successfully.
if file network path => package run failed.

checking network path:
can access network path , open file manually successful.

so question credential ssis package running?
if runs under account logg-in sql , call store, should access file. it's not. turns out credential substituted own.
after search quite long time, can't find answer.

any on appreciated.

this store execute ssis

alter procedure [dbo].[execute_ssis_package]  @folder_name varchar(100)   ,@project_name varchar(100)  ,@package_name varchar(300)  --,@runaccount varchar(300) output  ,@output_execution_id bigint output begin      set nocount on;   declare @execution_id bigint  exec ssisdb.catalog.create_execution @folder_name,            @project_name,            @package_name,            @use32bitruntime = true,            @reference_id = null,            @execution_id = @execution_id output   select @execution_id   declare @var0 smallint = 1  exec [ssisdb].[catalog].[set_execution_parameter_value]        @execution_id,         @object_type=50,        @parameter_name=n'logging_level',        @parameter_value=@var0   exec ssisdb.catalog.start_execution @execution_id  set  @output_execution_id = @execution_id

the credential runs ssis package:

if run sql agent, run agent user running windows service.

if run sql agent via proxy credentials, runs under credentials.

if run windows scheduler via dtexec, runs under user defined in scheduler.

in case, using stored proc, calls that?


Comments

Post a Comment

Popular posts from this blog

qt - Using float or double for own QML classes -

-
i've created components , helper methods using c++ , qt used in qml gui. of methods calculate gui elements (size, transformations, scene graph items creation). target arm 32 bit using opengl / eglfs render output. opengl using float , qml using real (defined double ). what should use in c++ do not lose precision? if use qreal ( double ) shouldn't lose precision. if git grep float in qtbase.git , can find out bit more: dist/changes-5.2.0-**************************************************************************** dist/changes-5.2.0-* important behavior changes * dist/changes-5.2.0-**************************************************************************** dist/changes-5.2.0- dist/changes-5.2.0- - qt compiled qreal typedef'ed double on dist/changes-5.2.0: platforms. qreal float on arm chipsets before. guarantees more dist/changes-5.2.0- consistent behavior between platforms qt supports, binary dist/chan...
Read more

Create Outlook appointment via C# .Net -

-
i need create outlook appointment using microsoft.office.interop.outlook , while can work locally on own workstation , works if run web application via server's browser, not work when connect server externally. hence, think might permission issue. i changed application pool identity " localsystem " don't access denied error. unfortunately, doesn't work. the app behaves if appointment created, appointment doesn't appear in outlook. here include file on top of aspx.cs page using outlook = microsoft.office.interop.outlook; here code using pop appointment. outlook.application apptapp = new outlook.application(); outlook.appointmentitem appt = apptapp.createitem(outlook.olitemtype.olappointmentitem) outlook.appointmentitem; appt.subject = txtfirstname.text + " " + txtlastname.text; appt.body = txtcomment.text; appt.alldayevent = false; appt.start = datetime.parse(txtreminderdate.text + " 8:00 am"); appt.end = datetime.p...
Read more

ios - Swift Array Resetting Itself -

-
i have 2 arrays: pointhistory , datehistory . have nstimer , , when timer runs out, action called. in action appending int pointhistory , , current date string datehistory . here timer action: func timeraction() { let steppervalue = int(stepper.value) employee.numberofpoints = steppervalue networking.saveemployee(employee, completion: { (error) -> void in if error != nil { let alert = uialertcontroller(title: "error", message: "there error updating \(self.employee.name)'s points", preferredstyle: .alert) let alertaction = uialertaction(title: "ok", style: .cancel, handler: nil) alert.addaction(alertaction) self.presentviewcontroller(alert, animated: true, completion: nil) } }) var dateformatter = nsdateformatter() dateformatter.dateformat = "mm-dd-yyyy" dateformatter.timezone = nstimezone.localtimezone() var date = nsdate() var ...
Read more