September 18, 2013 at 7:02 pm
Problem/Background:
Source database has a table that contains snapshot information about the statuses of a bunch of machines. When statuses change rows are updated with new statuses. Old statuses are lost.
There's a business need in my group to capture the status of these machines on a regular basis (The sampling rate is unknown to me, but it may be hourly, or daily.) and write that info to a table on another database so that we can begin trending.
I know SSIS has a script task I can use to get the result set I need and I'm comfortable configuring the connections to both source and destination servers/databases/tables. What I don't know how to do is automate SSIS to run the script task each hour.
Will you please give me some pointer what to google to find help on automating the hourly running of an SSIS script task? Perhaps there is a better control task to use?
Thanks.
--Quote me
September 18, 2013 at 7:26 pm
You're looking to use SQL Agent as the scheduler. Just use the following article to decide which way you want to schedule the job:
http://technet.microsoft.com/en-us/library/ms141701.aspx
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
September 18, 2013 at 11:18 pm
Thank you Matt!
--Quote me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply