If you are using SQL 2000 and have Package Logging enabled. You can check the Execution status in sysdtspackagelog.

An executing package will have a start time, but no end time....

For your unused connections, create a new connection with the same name, then delete them again.

For your second problem, does the sub-package execute ok by itself?

Hope this helps

Phill Carter

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

Colt 45...

What I meant to say was,

[quote-0}When you run the package manually in EM, it will use your security context, not the Servers.[/quote-0]

The error you posted looks like the error from...

Is the single SELECT statement necessary?

Could you acheive the same result by doing the '@id > 0' in an IF statement?

EG:

If @id > 0

Select for one nurse

Else

...

Another point to note in addition to the above, make sure you don't have "View Results in Grid" selected. QA tends to bog down pretty badly when viewing large resultsets...

Yes you can do this with DTS. However, it won't be as easy asjust setting up the DTS package in the wizard.

Can you set up the Access database as a...

You can also use an ActiveX Script task. In the past I've found this method a bit more flexible than the Dynamic Properties task.

For an example, check out this post,

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=16191&FORUM_ID=19&CAT_ID=3

Hope...

What do you need to use a temp table for?

Maybe you could assign the rowset to a Global variable and use it like an ADO recordset.

Hope this helps

Phill Carter

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

Colt 45...

You'll probably find more tools that translate Oracle to SQL Server than the other way.

Take a look at the following, it might or might not help,

http://www.vembu.com/products.html

This one should definately help,

http://technet.oracle.com/tech/migration/workbench/content.html

Hope...

What is the error message?

Does the account that SQL Agent is running under have access to the UNC path?

When you run the package manually in EM, it will your security...

Ok Frank ... I'll let you off this time because you did actually respond to the topic

Damn ... now I'm just posting to up my count...

Maybe the ExecutePackage task was pointing to an earlier version of the same package.

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

Also in the pricey range, but not as troublesome as ERWIN, is ER/Studio.

http://www.embarcadero.com/products/erstudio/index.asp

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

quote:

---

Zero Impact SQL Monitor

http://www.sqlpower.com/products.html

Spotlight for SQL Server

http://www.quest.com/spotlight_sql/

Microsoft MOM

http://www.microsoft.com/mom/

---

Just realised I mucked up a couple of...

quote:

---

One thing worth considering when deciding whether to run your package via a SQL Agent job, or via xp_cmdshell is timing of...