I need to make some SSIS workflow packages. I see I can do this in SSDT.
I have not used SSDT before.
It appears that SSDT installs into Visual Studio. OK, I can do that. (I have VS 2015 installed.)
But my workstation has no visibility to the SQL Server. The SQL Server is firewalled, etc.
Will I be able to author in a disconnected way in SSDT and then package a file that I can transfer to SQL Server?
If not, what is the workflow to author in the SSDT SSIS Designer and get the package to an isolated SQL Server?