{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: how to use a linked server:》','https://www.manongdao.com/q-704883.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I have added a linked server through MS SQL Server Management Studio successfully. It's name is SQL2_Link.
When I go to add a connection as ADO.NET Connection in SSIS, it will not show up in the list of available options.
How can I add this as an option for an ADO.NET Connection in SSIS.
I am using SQL Server 2008, BIDS 2008.
Thanks...!
EDIT
The Linked Server is using MS OLE DB Provider for ODBC DRIVERS
You wouldn't want to try to connect to the Linked Server in SSIS - just create a new connection to the database. If you've set the linked server up then I assume you have all the connection details - create a new ADO.NET connection with these details and use that as your source or destination as required.