SQL Server Performance

SSIS Package Issue

Discussion in 'SQL Server 2005 Integration Services' started by roopaprp, May 11, 2007.

  1. roopaprp New Member

    Hi ,
    I have probelm with excuting a stored Procedure through the SSIS package. When I am executing a stored Procedure in Query Analyzer it is running, but when I am putting that in SSIS package and trying to execute it, it is not even being initiated.
    How to fix this?

    Thanks

    Roopa
  2. MohammedU New Member

    Make sure the SQL connection manager account has the permission to execute the procedure...

    Check the SSIS log for errors...Post the error...

    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. satya Moderator

    Explain how you have deployed this SP in SSIS.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page