USP_DATAFORMTEMPLATE_EDITLOAD_IMPORTPROCESSOPTIONS
The load procedure used by the edit dataform template "Import Process Options Edit Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATALOADED | bit | INOUT | Output parameter indicating whether or not data was actually loaded. |
| @IMPORTFILEPATH | nvarchar(200) | INOUT | Import file path |
| @IMPERSONATE | bit | INOUT | Impersonate |
| @IMPERSONATEUSERNAME | nvarchar(200) | INOUT | User name |
| @IMPERSONATEPASSWORD | nvarchar(200) | INOUT | Password |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_IMPORTPROCESSOPTIONS(@DATALOADED bit = 0 output,
@IMPORTFILEPATH nvarchar(200) = null output,
@IMPERSONATE bit = null output,
@IMPERSONATEUSERNAME nvarchar(200) = null output,
@IMPERSONATEPASSWORD nvarchar(200) = null output)
as
set nocount on;
select top(1) @IMPORTFILEPATH = IMPORTFILEPATH,
@IMPERSONATE = IMPERSONATE,
@IMPERSONATEUSERNAME = IMPERSONATEUSERNAME
from dbo.IMPORTPROCESSOPTIONS
order by DATEADDED desc;
set @IMPERSONATEPASSWORD = 'g3(2=`-~405##@lZ91'; --Pass up a garbage password.
set @DATALOADED = 1;