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 Answer 1

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.

5
  • 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.) Apr 19, 2018 at 22:30
  • Developing on a production system is poor practice. You should develop somewhere safe where mistakes wont impact a prod system. Apr 23, 2018 at 2:11
  • I do not intend to dev against prod. But I do need to package it up to move it to prod. Apr 24, 2018 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. Apr 24, 2018 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) Apr 24, 2018 at 13:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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