There are a couple of things that could be happening here

1. Permissions are different when manual v scheduled.

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

and

2. http://support.microsoft.com/?kbid=290077


You do not say what SP level you are at but if you are less than SP3 I would
greatly suggest you do go to this.

A way to find out where the package would appear to be "spinning" is to run
a Profiler trace whilst running the package and seeing what it is doing.
Also with ref to #1 you may want to log in as the SQL Server Agent service
account and run the package manually. See if it stalls then.



--

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

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
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


"Lightermain" <lightermain (AT) flight (DOT) com> wrote

Obviously you need to find out what us causing the process to hang. Now this
probably
depends on what the package is doing, but a good start place is anything
that could raise an error dialog that waits for you to click OK.
Examples could be a badly written COM object, or a bad OLE-DB/ODBC
driver that decides to ask for credentials or just throws an error. Old
debug type MsgBox statements left in code is another favourite.
Obviously start by turning on all logging, task logs, package to file,
package to SQL Server, and the job step output to file option.

The problem may be caused by the change in location and execution context
that normally takes place when a package is scheduled compared to running on
a development workstation-

269074 - INF: How to Run a DTS Package as a Scheduled Job
(http://support.microsoft.com/?kbid=269074)


--
Darren Green
http://www.sqldts.com

"Lightermain" <lightermain (AT) flight (DOT) com> wrote

Have a look at some of these KBs as well-

318819 - PRB: A DTS Package Raises Exceptions or Stops Responding When You
Run It as a Scheduled Job
(http://support.microsoft.com/default...9&Product=sql2
k)


290077 - FIX: DTS Scheduled Job Does Not Complete After First Run
(http://support.microsoft.com/default...7&Product=sql2
k)


296533 - INF: Analysis Services Processing Task May Not Execute Correctly
(http://support.microsoft.com/default...3&Product=sql2
k)


282966 - DTS Package Fails with Dynamic Properties Task and OLAP Processing
Task
(http://support.microsoft.com/default.aspx?kbid=282966)


--
Darren Green
http://www.sqldts.com



"Lightermain" <lightermain (AT) flight (DOT) com> wrote

Hi all you Experts!



I have an SQL-8 running smoothly.

I've created few local packages that transform data from a server in a
different domain

running Tabula Database.

i have no problem running the packages manually and getting all the data i
need

I do have a problem scheduling the packages - the jobs seems to be running

but for some reason they never end and data is not transforming.



help help help

Thank you all for the help!

The problem was a bad ODBC Driver and was fixed.
It runs great now.

Keep on the good work


"Lightermain" <lightermain (AT) flight (DOT) com> wrote