Source Data field not populating in MSSQL TASK
Jothikrishnan asked 2 years ago
Hi,
I’m trying to create the Project Employee Access List through SQL Task while creating new employee records thru map. so Im passing Emp ID and Department Code from Source Query to SQL Task. Emp ID is being replaced but not the department code at all. Emp Record is being created with the same Emp Id and department code without issues. But not working on this task. I have tried at least 20 or more times but couldnt figure out why.
insert PA01408(PACONTNUMBER, PAPROJNUMBER, EMPLOYID ) SELECT distinct PACONTNUMBER, PAPROJNUMBER,’_GPEMPID’ from PA01201 p where p.PADepartment =’_DepartmentCodeNew ‘ and p.pastat in (1,4) except select PACONTNUMBER, PAPROJNUMBER, EMPLOYID from PA01408 with(nolock)
I’m trying to create the Project Employee Access List through SQL Task while creating new employee records thru map. so Im passing Emp ID and Department Code from Source Query to SQL Task. Emp ID is being replaced but not the department code at all. Emp Record is being created with the same Emp Id and department code without issues. But not working on this task. I have tried at least 20 or more times but couldnt figure out why.
insert PA01408(PACONTNUMBER, PAPROJNUMBER, EMPLOYID ) SELECT distinct PACONTNUMBER, PAPROJNUMBER,’_GPEMPID’ from PA01201 p where p.PADepartment =’_DepartmentCodeNew ‘ and p.pastat in (1,4) except select PACONTNUMBER, PAPROJNUMBER, EMPLOYID from PA01408 with(nolock)
Answers
Patrick Roth