Question about setting up SSIS in SSMS

  • itmasterw 60042

    SSCrazy

    Points: 2706

    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)

  • Site Owners

    SSC Guru

    Points: 80380

    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 2 (of 2 total)

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