Run package performance

i made a packge with sql task

this task execute stored procedure contains cursor

it take alot of time (arround 1 houre ), want increase the performance

note: sql2005 and sp2

please help

You might want to ask your question in the Transact-SQL forum and while there, provide the details of your stored procedure to them. I don't believe this to be an SSIS issue -- not yet anyway.|||The performance is not related to SSIS at all. Well, probably not.

How long does it take to run if you execute it through MSSMS?
if you have a cursor in the proc, this is most probably your problem and the code contain within it. SQL is not a row based language.

Use the SQL group for help on performance of the procedure.