3

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
  • 2
    and the error message is...
    – billinkc
    Nov 4, 2014 at 22:49
  • Just the standard can't find host, etc, etc
    – user51547
    Nov 5, 2014 at 17:53

1 Answer 1

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 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.