1

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?

1

Yes you can work offline but it will be difficult to develop and test without the input/output connections files/tables your package will use.

One option is to install SQL Server on your pc, create a database and copy the source and target tables and some test data to your pc. Then you can develop and test locally.

Deployment will be difficult unless you have ssdt on the server. Otherwise you will need access to deploy to the server from another machine.

  • If I can only effectively work in SSDT if it has access to the prod DB Server, that makes SSDT pretty useless. The prod DB server is pretty isolated. (And if SSDT is useless, SSIS is half useless.) – samsmith Apr 19 '18 at 22:30
  • Developing on a production system is poor practice. You should develop somewhere safe where mistakes wont impact a prod system. – Sir Swears-a-lot Apr 23 '18 at 2:11
  • I do not intend to dev against prod. But I do need to package it up to move it to prod. – samsmith Apr 24 '18 at 0:19
  • It is possible to develop and deploy the package to the file system. But my preference to to deploy to an ssis catalog db. – Sir Swears-a-lot Apr 24 '18 at 7:03
  • Got it. Agreed. My concern is that I do not yet understand how to package up packages from my dev, local env (which lacks SQL Server connectivity to PROD) to the Prod environment. (I can upload a file to prod, but then how do I import it into SSIS catalog on prod without Visual Studio or SSDT? I only have SSMS on prod) – samsmith Apr 24 '18 at 13:41

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.