I wonder why DTS OLE DB can't support auto schedule and any possible
solution?

Can you expand on your requirements. Are you referring to scheduling a DTS
package in which one of the connections in using SQLOLEDB?

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"samuel" <samuellai (AT) ajikl (DOT) com.my> wrote

yes, scheduling a DTS package in using SQLOLEDB.

Requirement?
- Download database record from IBM AS/400 DB2 into
MS-SQL Server 2000

Connectivity
- Manual schedule DTS package is workable

Issue
- Unable to schedule DTS package via auto schedule

Cause
- Suspect OLE DB doesn't support auto schedule DTS

However, when I chane OLE DB into ODBC, then the auto schedule DTS is
working and transaction records updated.

Please advise.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Never seen this one before.

Here is an article detailing oddities when scheduling packages

http://support.microsoft.com/?kbid=269074

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Samuel Lai" <samuellai (AT) ajikl (DOT) com.my> wrote