Hello Techie,

may some one please help me on below scenario.

i am using Oledb source with Data Access Mode as sql command.
the output of the script need to save in flat file.
The script contain temp table, inspite of retain same connection as true
and delay validation as True i am getting error (0x80040E14). can any one please suggest what might
be possible reason.

--SCRIPT

CREATE TABLE #temp
(
appid VARCHAR(11) PRIMARY KEY
) 
INSERT INTO #temp(appid) 
  SELECT appid
  FROM 
  (
  SELECT AppID,
  FROM Source.dbo.Src1
  )f
SELECT lefthand.appid,lefthand.name,lefthand.value AS original,Righthand.value AS changed
  FROM (
  SELECT Source.dbo.Src2.appid, 'BaseID' AS 'name',BaseID AS 'value'
    FROM Source.dbo.Src2 INNER JOIN #temp altered ON altered.appid=Source.dbo.Src2.appid

Thanks

• Edited by Pras05 20 hours 39 minutes ago

Hi Pras05,

Please follow the below link

https://www.mssqltips.com/sqlservertip/2826/how-to-create-and-use-temp-tables-in-ssis/

Hi Milan. 

Thanks for your response, but as i mention earlier i am changing the retain connection property and delay validation

i am getting the same error 

Regards

Pras05, can you post the error msg it is throwing. Are you trying to run through agent?

what ever the settings you have done should take care of it.