Pass SP as a source in Dataflow in ADF

Question

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 -

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 -

Thanks in advance.

Answer 1

Hi@Shivani Tyagi ,this has been discussed below:

https://stackoverflow.com/questions/61966410/stored-procedure-as-source-in-data-flow

Thanks