Post reply

want to search a sprocs used in SSIS package

  • September 4, 2011 at 8:35 pm

    #148595

    I have a parent package calls some child package.

    I know some step in the package that calls a stored procedure, but for so many tasks in the package, I cannot find it is hidden. Is there a way I can search to find which task is using the stored procedure by searching the stored procedu name?

    Thanks

  • September 5, 2011 at 3:40 am

    #1376982

    you could always search through the XML code of the dtsx package for the procedure name and this should also show you what task is calling the procedure

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply