Question about setting up SSIS in SSMS

  • Hi,

    We just set up SQL 2017 and I am trying to create a Catalog on it, which I have done before and it was fairly easy. However,, I am getting the following message saying that I am missing a DLL, which is now in the location; but was not in my 2012 server either.  I have full permissions on the system, so I am at a loss of what to do.

    Any ideas as to what I can do?

    Thank you

    Message:

    TITLE: Microsoft SQL Server Management Studio

    ------------------------------

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Management.IntegrationServices)

    ------------------------------

    ADDITIONAL INFORMATION:

    Cannot bulk load. The file "c:\Program Files\Microsoft SQL Server\140\DTS\Binn\Microsoft.SqlServer.IntegrationServices.Server.dll" does not exist or you don't have file access rights. (Microsoft SQL Server, Error: 4860)

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply