1)Open Sql Server Data Tools
2)Create New Integration Services Project
3)Right Click Connection Manager -> Select New Connection Manager
Select OLEDB Type
Select Exiting Data Connection or Create new connection
Rename 'DNS_DB.conmgr' (DNS sql database connection)
Independent Consultant - Web, Project Lead, Dynamics CRM 2015/2013/2011, BizTalk 2013/2010, .NET, JAVA, PHP, Python, SQL SERVER, MYSQL, XML, BigData, Hadoop.
Contact Me. I can help you on your project.