If you use ole methods and load and run the package using this then since each of the above(load, execute ) are seperate steps you could output this info.

We are Running sql server 2000 (version 8.00.2039, SP4) on a windows server 2000 machine.

This box has not changed at all, and there are no network changes that I am...

For this very reason and a few others about examing exceptions in a package immediatly after it has run. We have wrote a sproc which using ole methods to load...

Many thanks for pointing me in the correct direction David.

I never know this facility even existed depite the great big button on the general tab.

There are indeed some errors in the script, however It was the technique that I found invaluable(..and much appreciated). I modified it slightly to be :

Option Explicit

Dim conServer, oJB

Dim strFldr,...

Many thanks for that. This technique works a treat!!

Thanks, had a look into it abit further and did it by moving the datasource from within the RS interface.

However I have noticed that when I deploy a report fro...

Guys,

Thanks for the feedback and the links they are very helpful.

Jeet

The error I get back using sp_oageterrorinfo is:

Source: ODSOLE Extended Procedure

Description: Invalid class string

there is a system sproc called 'sp_who2 active' and in the row for your process if the column blk has a value it tells you the processid of the blocking process.

so...

Are you sure the program is hanging??, and it's not that the query is being blocked??

Have you tried setting the command timeout property on the command object (CommandTimeout) to zero. i.e.

oCmd.CommandTimeout = 0

This tells ADO to wait for the command to complete. You may still get...

The way we have done this is to have a DTS package which contains soe VB script to load in the xml file using the OpenTextFile FSO method. The xml file will...

If it's just DTS packages you are interested in, you only need the content of the table msdb.dbo.sysdtspackages

Jeet