Did a bunch of hunting, but I have a SQL 2012 Developer instance that's on an isolated network (no internet access, except for VPN to it). At install time we didn't install integration services, and my developer needs to deploy/configure SSIS packages.

I tried a few things, and got stuck. Part of the issue is that we appear to need some flavor of VS, and I'd assumed that I already had it per below.

enter image description here

Would appreciate a step by step.. keeping in mind that whatever I put on the machine can't be dependent on getting files from the internet.

  • 2
    For SSIS you can download and use SSDT (Sql Server Data Tools) – McNets Apr 13 '18 at 12:52
  • Understood; however, is that enough, or does one need some flavor of Visual Studio installed? and also, where can I find an offline SSDT installer (remember, we have no internet access). What I tried to install, was trying to download pieces from MS. – Kendor Apr 14 '18 at 22:02
  • Yes, SSDT installs a minimal Visual Studio framework – McNets Apr 15 '18 at 17:57
  • @McNets can you point me to where I can find offline SSDT installer? – Kendor Apr 15 '18 at 21:54

You have to create an administrative install point:
SSDTSetup.exe /layout <destination>
then copy the files to your isolated instance. Check out https://blogs.msdn.microsoft.com/ssdt/2014/07/23/creating-an-administrative-install-of-ssdt-update-for-visual-studio-2013/ for details.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.