"Yash" <Yash@discussions.microsoft.com> wrote in message
news:3A7867F9-07DA-4B1F-8FFC-3BE82A65CA97@microsoft.com...
> 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
>

"Allan Mitchell" wrote:

> 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@discussions.microsoft.com> wrote in message
> news:3A7867F9-07DA-4B1F-8FFC-3BE82A65CA97@microsoft.com...
> > 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
> >
>
>