{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 成全新的幸福 的问题《SSIS package not inserting records when run as Job》','https://www.manongdao.com/q-1089460.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
Hi I want to run my SSIS package as job. I have successfully created job and package. It runs without any error but it is not inserting records to the database.
But when I run the same package using DTEXECUI.EXE It is inserting records in the database. Please help.
As discussed, it was discovered that the package was using
Environment Variablesas part of the connection manager, SQL Server/Agent/SSIS service needed to be restarted for these new variables to be picked up.