Session Execution

What is the first one executed in a session? Is it the Truncate Target Table option or the Post SQL? Explain

Questions by pinky_pinkstar

Showing Answers 1 - 6 of 6 Answers

nova84

  • Jun 23rd, 2008
 

Truncate Target table:
Integration Service truncate target tables before running a session.Depending on the target database and primary key-foreign key relationships in the session target, the Integration Service might issue a delete or truncate command.

Post -SQL :

Enter post-session SQL commands to execute commands against the target database after the Integration Service writes to the target.

  Was this answer useful?  Yes

Mamta11

  • Oct 14th, 2008
 

Truncate table will be executed first.
Trunc. table gets esecuted before the table starts loading and post SQL executes after the session is completed (table loaded)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions