Hello there,

I have a statement running in DTS.

SELECT COALESCE( MAX(colID ), 0 ) AS LastID FROM TableName

Output of this row is stored in Global variables; on successfully completion
of this step; the next step a transformation task defined as

select * From TableName where colId > ?

Source data is from Oracle 9i Server to SQL Server for warehousing

Now the problem, this package hangs for unknown reasons; no trace; no locks,
no logs.

From last few days its hanging more frequently.

Server Details : Database is running on Windows 2003 Server, SQL Server 2000
Ent Edtn SP3a applied

Is this a bug; has anyone faced this problem. please.......... help :-)

Any help appreciated....,

--
Regards,
Yash

What happens on Oracle?
Oracle is the source so do you see the statement being issued?

Can you do the statement manually using another tool (TOAD)?
Are you getting anything in the event logs?
Does it work from another box?



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Yash" <Yash (AT) discussions (DOT) microsoft.com> wrote

Yes, i tried using Toad to see if there is any problems, but no traces at
all; no locks in Oracle also.
But if i kill the job and restart it it goes on with any troubles. But pops
up after few days. To me it feels like the DTS is not picking up the next
statement.
Why, no clue....? I might have to re design this part of DTS package :-(
--
Regards,
Yash



"Allan Mitchell" wrote: