Pass SP as a source in Dataflow in ADF

Shivani Tyagi 106 Reputation points
2022-11-14T10:06:55.123+00:00

Hi,

I have a requirement where I want to fetch the details of an employee from the SP and pass it as a source in dataflow.

My source settings are as follows -

259999-image.png

260020-image.png

My Sp is - >

ALTER PROC [HR_History].[sp_GetEmployeeDetails]
@crtd_dt DATETIME
AS
SELECT
[empID] as [Employee Id]
,[empFName] as [Employee Forename]
,[empLName] as [Employee Surname]
,[empStartDate] as [Employment Start Date]
,[empDepartment] as [Department]
,[empTeam] as [Team]
,[empJobTitle] as [Job Title]
,[empUsername] as [Employee Username]
,[empFullName] as [Employee Full Name]
,[empCRMRole] as [Job Role]
,[empCRMDept]
,[empTrainingStatus] as [Training Status]
,[peopleHRID] as [PeopleHr Id]
,[SHA2_256_All] as [SHA2 256 All]
,[Created At]
FROM [HR_History].[EmpMain] em WITH (NOLOCK)
WHERE [Created At] <= @crtd_dt

But I am getting this error -

260112-image.png

Thanks in advance.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,093 questions
0 comments No comments
{count} votes

Accepted answer
  1. Samy Abdul 3,366 Reputation points
    2022-11-14T10:16:10.303+00:00
    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful