PsDataFactory is a PowerShell module to generate DataFactory pipelines and datasets.
Creates a SQL Server stored procedure activity.
New-AdfSqlServerStoredProcedure -Name <String> -LinkedServiceReference <PSObject>
-StoredProcedureExpression <String> [-Timeout <Object>] [-DependsOn <Object>]
[-ProgressAction <ActionPreference>] [<CommonParameters>]
New-AdfSqlServerStoredProcedure -Name <String> -LinkedServiceReference <PSObject> -StoredProcedureName <String>
[-Timeout <Object>] [-DependsOn <Object>] [-ProgressAction <ActionPreference>] [<CommonParameters>]
Creates an activity that invokes a stored procedure using the supplied linked service. Specify either a literal procedure name or an expression.
New-AdfSqlServerStoredProcedure -Name 'RunProcedure' -LinkedServiceReference $linkedService -StoredProcedureName 'dbo.LoadData'
Creates an activity that invokes the specified stored procedure.
The activity name.
Type: String
Parameter Sets: (All)
Aliases:
Required: True
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
The linked service reference used to connect to SQL Server.
Type: PSObject
Parameter Sets: (All)
Aliases:
Required: True
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
An expression that resolves to the stored procedure name. Used with the Expression parameter set.
Type: String
Parameter Sets: Expression
Aliases:
Required: True
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
The literal stored procedure name. Used with the Name parameter set.
Type: String
Parameter Sets: Name
Aliases:
Required: True
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
The activity timeout. Defaults to 12 hours.
Type: Object
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0.12:00:00
Accept pipeline input: False
Accept wildcard characters: False
The activity dependencies. Defaults to an empty array.
Type: Object
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: @()
Accept pipeline input: False
Accept wildcard characters: False
Type: ActionPreference
Parameter Sets: (All)
Aliases: proga
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.
https://abbgrade.github.io/PsDataFactory/docs/New-AdfSqlServerStoredProcedure.html