Hi there,
I just created a DTS package to copy data from an oracle system to MS SQL
2000 Server. However when I try to edit the data within my table on MS SQL
2000 after been exported, I get the error messsage "Transaction cannot start
while in firehouse mode" any idea whats causing this ?

Thanks,
Liam

That is because the data in EM is fetched using a Firehose cursor which is
Fast Forward and Read Only. You will need at the very least to scroll all
the way to the bottom of the data before being able to do anything.

I would avoid doing updates to data in here anyway. Use QA and UPDATE,
DELETE statements

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Liam Mac" <LiamMac (AT) discussions (DOT) microsoft.com> wrote