Home Forums Data Warehousing Integration Services Metadata error in SSIS when using Openquery and ADSI when Project deployed to SSIS Server RE: Metadata error in SSIS when using Openquery and ADSI when Project deployed to SSIS Server

  • May 21, 2018 at 1:04 pm

    #1991340

    Phil Parkin - Monday, May 21, 2018 10:20 AM

    If the error happens only when you run the package from SQL Agent, it's probably a permissions issue. Does the SQL Agent user have rights to query AD?

    Yes, I've verified the user the SSIS process is running has the appropriate permissions.  Also I have another step pulling AD Group information over the same connection in the same package which is working without issue.  I had to use Result Set for it, but this didn't work for the one pulling AD User information.

    Sam