sql server dts: Hi,

I am looking for some help with putting a solution together that will
poll for a file say between 7am and 9 am once the file is available it
will trigger a DTS job.

I am unsure as to how I should go about this, Any help would be much
appreciated.

Thanks

You can use the SQLServer Agent scheduler to do the scheduling.

The package checks for the file

How can I check if a file exists?
http://www.sqldts.com/default.aspx?6,103,211,0,1

If it finds it then it enables the Datapump task and if not it exits
gracefully (Workflow)

Multiple Paths in Workflow
http://www.sqldts.com/default.aspx?6,103,218,7,1






--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



[quoted text, click to view]

You can use the SQLServer Agent scheduler to do the scheduling.

The package checks for the file

How can I check if a file exists?
http://www.sqldts.com/default.aspx?6,103,211,0,1

If it finds it then it enables the Datapump task and if not it exits
gracefully (Workflow)

Multiple Paths in Workflow
http://www.sqldts.com/default.aspx?6,103,218,7,1






--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



[quoted text, click to view]