Error while running a SSIS package with SQL JOBS

avihus 0
Viewed 40

i am using SSIS , visual studio 2017 .
cant find a solution to my problem anywhere.
i deployed a package that has 3 children that they are also packages , inside each package there are sql tasks and data flows that imports a databases to my own data base.
**if i run this SQL JOB manually** it works , if i set a job to a certin time i get errors.

what could be the problem?

following errors:
0xC0012050
DLN1 Error: 0xC0208449
0x80070003 enter image description here **there is an error uploading an image with the errors **

i searched the web but there is nothing

ssis-2012 ssis sql-server
2 Answers

The answer to your question is right ther in the error message: "Login failed for user bytes2story". When you configure a job step an tell it to execute a SSIS package, you can provide a user as which the execution of the package should be performed. Most certainly the user you chose is lacking privileges. Check the privileges of the user bytestostory or choose another user.

Tyron780

if there is a package that contains other packages then there is a problem. the solution is to run all packages that have dataflows(without other packages) by them self.

for some reason SSIS cant handle packages with children

avihus0
Related