CODEWITHSUNDEEP
sql-serverssis
MZEN
MZEN

Reputation: 155

SSIS Master package gives The specified schema name either does not exist or you do not have permission to use it error but child package runs

I have a master package which calls 2 child packages (execute package task) within same SSIS project. The child package runs successfully with no errors however when it returns to the master package, it gives error:

The specified schema name (dbo) either does not exist or you do not have permission to use it

None of my statements reference the DBO schema, they all reference the schema I have permission to use.

I'm using Visual Studio 19

Upvotes: 0

Views: 981

Answers (1)

MZEN
MZEN

Reputation: 155

Found the solution: The connection manager was erasing itself when opening the SSIS solution file, however the packages ran flawlessly when opening the project file (.dtproj) instead of the (.sln) file. I believe it has something to do with the connection manager being project level.

Upvotes: 1

Related Questions