2

I have a job running on SQL Server 2012, where one of the steps is of type "SQL Server Integration Services Package". For the "Package source" I choose SSIS Catalog. For the "Server", if I type in the name of the server, everything works fine, but if I type in localhost I get an error.

How do I specify that the SSIS Catalog that I want to use is under the same server where the job is running?

  • 2
    and the error message is... – billinkc Nov 4 '14 at 22:49
  • Just the standard can't find host, etc, etc – user51547 Nov 5 '14 at 17:53
1

You can reference the local server with a period .

If you have an instance name, too, then use .\instancename

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.