Use SQL Server Agent Jobs. This is SQL Server's mechanism for scheduling.
If you want to schedule your package then right clicking on the package icon
in "Local Packages" | Schedule will create a job for you.
You have created the package right ?
Also be aware of this
http://support.microsoft.com/?kbid=269074
--
----------------------------
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
"Kwong" <anonymous (AT) discussions (DOT) microsoft.com> wrote
Quote:
I want to set schedule for data transfer from IBM AS/400
daily.Please show me the steps. Thank you. |