asked
SQL Server Data Tools
I have been using SQL Server 2012 Data Tools to build packages to import DB2 data. Now I need to find out if this can be done on individual workstations so the work can be delegated and not require being on the server. I installed what I thought was a workstation version from here
https://msdn.microsoft.com/en-us/hh500335(v=vs.103), which installed Microsoft Visual Studio - It looks and feels different than the full blow server version. Can I use this version to create Data Flow Tasks with OLD DB source and destination? Thank you, Tammy
There is no desktop version and server version of SSDT. You can install SSDT from the SQL Server 2012 installation media but 2014 and beyond will not include it. SSDT from the 2012 media will install VS 2010. VS 2010 is no longer under support for SSDT and you are advised to upgrade to 2012 or 2013. You can download SSDT from [this link][1], just click on the "Get It". If the work needs to be delegated you should just automate the process with SSIS and SQL Server. Then it no longer requires you to keep up with multiple installations of SSDT. [1]:
https://msdn.microsoft.com/en-us/data/tools.aspx
16 People are following this question.
