SSIS Package Issue | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SSIS Package Issue

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
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.
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.
]]>