I am also getting the same error on a DTS which previous worked fine - anyone else had this issue - as the previous poster stated I think it is...

Managed a "work around" - linking into an Access database which in turn is linked to the Oracle data source returns ths full text string and not just the first...

You can pass Global Variables into a DTS package via the dtsrun utility. Please see the below link for the full run down

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_dtsrun_95kp.asp

Hope this is of help

Do you require just the last 3 minutes from the table? Also how often will you be running the package?

In an ideal world I would want the package to run as one job - it is easier to administer and check the steps are running in the correct order.

I...

If you can only take one take the first and try to get the books for the second!