May 25, 2009 at 10:34 am
Hi Frieds,
I created a stored procedure .I need to execute the sp on dialy basis using SSIS.So I need to schedule the sp to execute say at 11.00 PM using SSIS.Can anybody help me for this?
Thanks in Advance
May 25, 2009 at 10:46 am
Hi
If you just want to execute the procedure you should consider to use a simple SQL Server Agent job.
If you really want/need/have to use SSIS use a "Execute SQL Task".
Greets
Flo
May 25, 2009 at 10:54 am
Yes I need to use SSIS for scheduling the above task.This request I got from our client.So I need to schedule a sp using SSIS
May 25, 2009 at 10:57 am
So use a "Execute SQL Task" as I wrote.
Greets
Flo
May 25, 2009 at 11:54 am
You can't schedule using SSIS - SSIS is not a scheduler product. You can use SSIS to process the stored procedure, or as Flo mentioned using the Execute SQL Task to execute it.
But, there is nothing in SSIS to set it up so it can run at a certain time every day.
To schedule it, you need to using either SQL Server Agent or Windows Task Scheduler or some other scheduling product.
From within SQL Server using SQL Server Agent is the generally preferred method of scheduling jobs. From there, you can easily schedule an SSIS package to run - which would then execute your stored procedure. But, if that is all it does - why the hassle of wrapping the execution of the procedure in an SSIS package? Just execute the procedure directly.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply