Because statement Select * in Procedure ABC uses a temp table..
Error at Data flow Task [OLEDB Source]:Unable to retrieve column information from the data source . Make sure your target table in the database is available.
Can you help me with this error ?
When I ran the procedure from outside its working fine but I am unable to run through SSIS package.