Executing SSIS package( which has script task) in ADF

Occasional Visitor

Hi Team,

 

We are trying to call ssis package in Azure Data Factory using Execute SSIS Package component in  pipeline and also tried to execute the same SSIS package in SSIS -IR (SSISDB catalog) , it was executed successfully in both ways because it was just having Data Flow Task (reading csv file and loading to SQL MI database) we used UNC path as source file connection manager. 

Problem : When we tried to call different SSIS package which has script task component, it was returning errors as below.

Could you please share your thoughts on same.

Thanks,

Kartheek Pichani
ADF Error Script Task.PNGSSIS-IR Error Script Task1.PNG


0 Replies