1


I have an SSIS package which is as below.
The DelayValidation Property of data flow task is True
The DelayValidation Property of all Execute SQL task is True
The RetainSameConnection Property of Source connection task is True
The Package runs fine on my local machine but when it is deployed on Server, it gives the error.
How can this be fixed? Please help.

SSIS Package
Data flow task
Error Screenshot
enter image description here

Meen
  • 119
  • 3
  • 15
  • Any reason you're using a global temp table? Why not just a permanent table, it saves a lot of hassle – Nick.Mc Aug 29 '22 at 09:53
  • A temporary table (even a "global" one) only lasts as long as the connection/scope that created it. You *can't* reference your temporary table on your latter Execute T-SQL task as it no longer exists; it has been implicitly `DROP`ed. – Thom A Aug 29 '22 at 11:14
  • @Nick.McDermaid I have to use the Global temp table because i don't have access to create Permanent table on Source DB. – Meen Aug 29 '22 at 11:17

0 Answers0