Hey,

Not sure how ingres handles datetime, but assuming that it will convert strings in the YYYYMMDD format into dates, this script might be helpful for you...

select CASE DATEDIFF(mi,...

for the first question, a step failure doesn't mean a package failure, you can define that in your package/step properties.

for the second one, the activexscript on the workflow is to...

I agree with everybody else that an ActiveX Script task is not the best way of achieving this, but if you insist to do so... I guess u must have...

Another thing you can do is get the result of that function into a global variable, and in the workflow properties of that Execute SQL Task, you specify that if...

If you are using a Job to execute your DTS, you can read the sysjobhistory table, and in there you can find the run_date and the run_status of the last...

as far as I know, DTS won't run parallel tasks if they are using the same connection to the database.

Let me see if I got ur problem right, you have...

Sounds like ur destination is stuck to the old database name...

usually when you create a new transform data task it sets the destination to something like "database1.dbo.table", so if...