DTS execution error -- sql server dts

Dhaval
7/21/2003 10:19:57 AM

Hi

Dhaval made DTS to fetch data from oracle. While exectuing
a particular step it gives me the following error. It
fetches around 35,00,000 records and it gives me error at
around 34,00,000 record. can any one help me in this...

Error description Description:
Error: 1204, Severity: 19, State: 1
The SQL Server cannot obtain a LOCK resource at this
time. Rerun your statement when there are fewer active
users or ask the system administrator to check the SQL
Server lock and memory configuration.

Regards

Allan Mitchell
7/22/2003 7:52:09 AM

Have a look at this in BOL

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\trb
lsql.chm::/tr_reslsyserr_1_6gxg.htm
--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]

sql server dts : DTS execution error