SQL Server Performance

Post Execute() - How to write?

Discussion in 'SQL Server 2005 Integration Services' started by AJITH123, Feb 17, 2009.

  1. AJITH123 Member


    Hi,
    How to write Post Execute () code in ssis, since i have a SSIS package which is having the post execute code, but i could not see any script component belongs to the script. Can we write the post or pre execute script with out component?
    I am pretty new to this? Can any body reply the same.
    Thanks
    Ajith
  2. satya Moderator

    Have you looked at Execute SQL task and also Script Task in the Control of Flow to write to and read from package variables.
  3. AJITH123 Member

    • Thanks for the reply, finally i got a script component, where the script was! since the package was big, using a lot components, so it was difficult.
    • Is any easy way to find the component, when we see a script in notepad? [any reference nuber ].
  4. satya Moderator

    Do you see any naming convention for your script?
  5. AJITH123 Member

    Hi Satya,
    The script was not writen by me, so it is pretty diificult to get it through naming convention...only thin i can see the array element id, but that is not helpfull for me..any way i just asked any way to find the same..
    Thanks for your reply..

Share This Page