They do the export for another table we use in another system OK. I think it's just that they only have the Oracle experience and not MS SQL or DTS.

Thank you for replies. The transform is a simple one, all work on the data is done using updates after the update.  We are currently importing a table that takes 2h...

We use a dynamic properties tasks to disable the next step in the job - thus causing the rest of the package not to run. This seems to work quite well and allows...

We originally had this problem but as we run the top level packages from dtsrun we pass the global variable as a parameter through as blank and then pass this down...

Just to let you know that the upgrade solved the problem. Perhaps because it was developed on sp3a.

Thanks for help

http://www.amazon.com/exec/obidos/redirect?tag=sqlservercentral&path=tg/detail/-/1861004419/qid=1097164856/sr=8-1/ref=pd_csp_1?v=glance&s=books&n=507846

I used this, for a long time it didn't leave my side, now I only need it occaisionally but I would recommend it.  It was also the book that got me...

Unfortunately this doesn't help as I wanted it to solve my problems. I will get the upgrade done however as we do consider this a basic there are security improvements...

The problem appears to be in the area where we clear the package id. Usually this has the effect of simply calling by name but I don't think it's happening...

Thanks,

The problem is not related to these points, which I know well and are good points to make,  but something to do with the Oracle data types I believe (which I...

I'm not a .net programmer.  We are connecting from SQL 2000 using a linked server, this in turn is used by DTS to read into a SQL database.  What we've downloaded...

Unfortunately the documentation doesn't make enough sense to me and we are using the free Oracle instant client.  We have made progress by changing to OLE DB for Oracle but...

This is usually to do with the data in the first rows.  Assumptions are made about the data type in the first 100 rows, if something gets picked up later...

What exactly is the error message and how are you trying to link to Oracle?  Is the problem that the package won't run or that the package runs and errors. ...

Sorry,  gvFileLocation is used as a global variable set to a favourite local directory (e.g. c:\SQL Packages\Connections

I'm after a list of column pairs in each tranformation of the DTS package.

e.g.

Transformation_1

Col1 , ColA

Col2, ColC

Col3, ColD

etc..

I know the input and output tables but can't find out how to...