Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kunaaldesai
Starting Member
36 Posts |
 Posted - 2009-10-26 : 23:33:17
|
| Hey guys, I was just wondering if there is any facility like timer in SSIS which basically runs a package every 5 minute?Kunal |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kunaaldesai
Starting Member
36 Posts |
Posted - 2009-10-27 : 01:03:42
|
| Thank you very much for your post. That was really helpful. But I have unique problem. May be you can add some insight into that. In article, they refer to changing values of security properties in Data Flow task. They do this to let package being configured as a job. Thats fine. But The problem with me is that I don't have any dataflow task , my whole package is defined in Control flow task and I am having one For each loop file container in that which basically moves some files from on location to another. And I want this task to run at a regular interval and that is the reason, why I am using this Job Scheduler.Now, my question is that how can I set security property when i don't have any task in data flow. Moreover, In data flow property window, it even does not show any security section or Protected property as stated in the article. I am am not sure why I am not able to see this option.Can you please guide me over this?Anything |
 |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-27 : 05:09:11
|
| What article are you referring to?You can schedule a package without a data flow.Have you tried to schedule a job in SQL Server Agent? |
|
|
|
kunaaldesai
Starting Member
36 Posts |
Posted - 2009-10-27 : 21:01:53
|
| Oh yes, Now I am scheduling it from SQL server agent. Thank you very much.Anything |
|
|
|
|
|
|
Timer in SSIS