Forum Discussion
A database operation failed with the following error: 'Invalid object name
When creating a SQL dataset, the 'Test Connection' operation succeeds but when I try to import schema, I get error 'SqlErrorNumber=208,Class=16,State=1'. The linked service has DB Name as parameter and it succeeds on some tables and errors out on others. It happens across multiple databases with no apparent pattern. Please chime in if you have encountered similar issue and hopefully solved it. It just driving me crazy and bringing my work to hault. Thanks in advance.
- As a workaround, instead of using connection string as key vault secret, I used password option and it worked. Keeps my work going...
