SSIS error : ‘Unable to retrieve column information from the data source. Make sure your target table in the database is available.’

I encountered this error while calling a stored procedure in SSIS one day. The stored procedure was calling Oracle via a linked server. Evidently when SSIS calls a stored procedure it gets a set of fields, but since the linked server call couldn’t give it a compiled list of fields it was causing an error. To fix the problem all … Read More

Mike GriffithSSIS error : ‘Unable to retrieve column information from the data source. Make sure your target table in the database is available.’