I came up with this active-x script that prompts for a package and then lists all the connection details.  You should be able to get a list of packages from...

Where I've had this before I've selected the SQL Query option and then Build Query.  This gives you a list box that can be re-sized and you can do the...

If you use the Import/Export wizard you can create a package that will generate the export of all the data into the Oracle database.  You can do this by hand...

The connections are OK if you run from within EM.  The problem also occurs when you run from a stored procedure in QA, does this get affected by the SQL...

Unfortunately this solution must be automatic so QA is not an answer, fortunately there are only a couple of fields that need quotes so I've managed to include them as...

I'm fairly certain that we went straight to SP3a on all servers.

Thanks for this. The output is great but I need column headings to be on the first line and a couple of fields hold commas so I think I will...

I think the SQLAdmin only has access to the SQLAdmin mailbox and my personal one only has access to my personal  mail box.  It seems strange that i can't run...

If possible I've found that it speeds things up if you can split queries like this this down, perhaps using intermediate table to hold the summary figures and then linking...

Sorry,  I meant that not having headings can cause a problem as the transform task then doesn't know what to call each item being transferred.  I suppose you might get...

I'm not familiar with the code here but does each column have a heading?  I've known this to cause problems.  Also (I think you say that you do this), does...

I come across two common problems that may be relevant. 

1. When you run a package using EM from a client then the connection used is taken from the client (i.e....

I've been watching this one for a while and I'm still wondering if a DTS package actually runs within a SQL server at all.  Surely as DTS can be redistributed...

Is it possible that it's trying to use the variable before it's been set?  It's worth checking the workflow thoroughly.  I go into disconnected edit for double checking as it's...

How about:

Write the value in the global variable to a table in SQL Server (one table, one row, one column)

Transfer this into a matching table in Oracle (delete anything in...