Hi Kevin,

I've created a simple sproc which uses #temp table and tried to execute using Execute sql task in Dts.

I was able to successfully execute the task independently (Right...

Thanks for the reply Kevin.

But how the sproc can successfully got executed in query analyser but not in the Execute sql task?

Is there any limitation(like using #temp tables) of running...