{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', '推荐 别忘想泡老子 的问题《Getting error running SSIS package on non-SSIS Ser》','https://www.manongdao.com/q-811631.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
This question already has an answer here:
I'm working in SSDT 2012. I've created a DTSX package that I have deployed to a SQL Server that does not have SSIS installed. My undertstanding is that this should work.
However I keep getting the following error: To run a SSIS package outside of SQL Server Data Tools you must install Derived Column of Integration Services or Higher.
I'm not really sure what's going on here. Does anyone have any insight for this. I've asked our DBA to install SSIS on the machine but I'm only guessing. This may not work and I would like to get ahead of this if I can.
Thanks for any feedback.
For the package to execute on the server, you do need to have SQL Server Integration Services engine installed on the server.