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
    AJITH123, Feb 17, 2009
    #2

  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.
    satya, Feb 19, 2009
    #3

  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 ].
    AJITH123, Feb 19, 2009
    #4

  4. satya Moderator

    Do you see any naming convention for your script?
    satya, Feb 19, 2009
    #5

  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..
    AJITH123, Feb 20, 2009
    #6

Share This Page