2 added 44 characters in body
source | link

This seems like you are running SSIS package through SQL agent job and error details are not accurate in your question,to know error details ,know name of package and run below query

use ssisdb
go

select top 10* from catalog.event_messages ce
join
catalog.operations co
on co.operation_id=ce.operation_id
and co.object_name='your package name'
and ce.event_name='onerror'
order by co.operation_id desc

use ssisdb  
go   

select top 10* from catalog.event_messages ce  
join  
catalog.operations co  
on co.operation_id=ce.operation_id  
and co.object_name='your package name'  
and ce.event_name='onerror'  
order by co.operation_id desc

please post the error

This seems like you are running SSIS package through SQL agent job and error details are not accurate in your question,to know error details ,know name of package and run below query

use ssisdb
go

select top 10* from catalog.event_messages ce
join
catalog.operations co
on co.operation_id=ce.operation_id
and co.object_name='your package name'
and ce.event_name='onerror'
order by co.operation_id desc

please post the error

This seems like you are running SSIS package through SQL agent job and error details are not accurate in your question,to know error details ,know name of package and run below query

use ssisdb  
go   

select top 10* from catalog.event_messages ce  
join  
catalog.operations co  
on co.operation_id=ce.operation_id  
and co.object_name='your package name'  
and ce.event_name='onerror'  
order by co.operation_id desc

please post the error

1
source | link

This seems like you are running SSIS package through SQL agent job and error details are not accurate in your question,to know error details ,know name of package and run below query

use ssisdb
go

select top 10* from catalog.event_messages ce
join
catalog.operations co
on co.operation_id=ce.operation_id
and co.object_name='your package name'
and ce.event_name='onerror'
order by co.operation_id desc

please post the error