I want to use below Query on my OLE DB Source in SSIS
SET FMTONLY OFF
DECLARE @cmd AS NVARCHAR(4000)
SET @cmd = (Select SqlQuery from SQLSource
Where id = 1)
EXEC sp_executesql @cmd;
I am reading Source SQL Query from the table and Data Element should always be same. Please advise.
Here is the error that I am getting, BTW I am using 2014.
'Unable to retrieve column information from the data source. Make sure your target table in the database is available."