| Author |
Topic |
|
twhitle
Starting Member
11 Posts |
 Posted - 2007-12-20 : 13:51:00
|
| I have a package that verifies if a file is present and would like to schedule it to run automatically. The file may or may not be available during the time I need it to be, so without some sort of sleep or idle if it fails, it will just bomb. Is there a way to make a scheduled DTS sleep after it verifies a file is not available, possibly for a certain amount of time???Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-20 : 13:53:42
|
| Why not just code for this situation?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
twhitle
Starting Member
11 Posts |
Posted - 2007-12-20 : 13:58:02
|
I am still learning. What would you suggest? An IF in the verification script?quote:
Originally posted by tkizer
Why not just code for this situation?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-20 : 13:59:43
|
| I have no idea what you are doing inside your DTS package as you haven't provided that information. So it makes it very hard to help out.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
twhitle
Starting Member
11 Posts |
Posted - 2007-12-20 : 14:01:19
|
I am loading a txt file to a table. I have an active x script that verifies whether or not the file is there. If the file isn't there, it fails. I would like to schedule it, but need some sort of condition that states if the file doesn't exist, or if it fails, to sleep or re-run after x amount of time.quote:
Originally posted by tkizer
I have no idea what you are doing inside your DTS package as you haven't provided that information. So it makes it very hard to help out.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/
|
|
|
|
twhitle
Starting Member
11 Posts |
Posted - 2007-12-20 : 14:27:10
|
Does anyone know what I'm trying to do???????quote:
Originally posted by twhitle
I am loading a txt file to a table. I have an active x script that verifies whether or not the file is there. If the file isn't there, it fails. I would like to schedule it, but need some sort of condition that states if the file doesn't exist, or if it fails, to sleep or re-run after x amount of time.quote:
Originally posted by tkizer
I have no idea what you are doing inside your DTS package as you haven't provided that information. So it makes it very hard to help out.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-20 : 15:29:07
|
| Did you honestly expect a reply in 20 minutes? You need to have patience when asking for free help. All of us have jobs and families. We are not just continuously checking to see if you've provided enough information yet.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
twhitle
Starting Member
11 Posts |
Posted - 2007-12-20 : 16:06:25
|
Someones having a bad day. Don't reply to it then. Thats why I said "anyone else".I wasn't trying to be hasty. Thanks anyway for the vent.quote:
Originally posted by tkizer
Did you honestly expect a reply in 20 minutes? You need to have patience when asking for free help. All of us have jobs and families. We are not just continuously checking to see if you've provided enough information yet.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/
|
|
|
|
|
Maing scheduled DTS job SLEEP!?