Hi People!

We updated our SQL Server 7.0 to have MDAC 2.7. It seems we are gonna have
to roll it back to 2.5. DTS packages run fine if we kick them off ourselves
but as soon as we schedule it to run from the agent, it hangs. I tried from
the command line, running the DTS package using DTSRun and it does actually
run and it gets the data but it never completes. This must be due to MDAC
as it happened the day that I changed it and hasn't worked since. I have
now been told that I have to rollback to what it was before. Has anyone
done this before and could you please give me some help.... It will be
greatly appreciated!!

Thanks
Meg :o)


**********************************************************************
DISCLAIMER
Any opinions expressed in this email are those of the individual and not necessarily of Mondial Assistance (UK) Ltd. This email and any files transmitted with it, including replies and forwarded copies (which may contain alterations) subsequently transmitted from the Company, are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited.

If you have received this email in error please notify the IT support desk by telephone on +44 (0)208 2393984 or via email to
[Email Address Removed] including a copy of this message. Please then delete this email and destroy any copies of it. Thank you.

Mondial Assistance (UK) Ltd
Mondial House
102 George Street
Croydon
CR9 1AJ

Mondial Assistance (UK) Ltd Registered in England No.1710361 Registered office as above
**********************************************************************


________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service. For more information on a proactive anti-virus service working
around the clock, around the globe, visit http://www.messagelabs.com
________________________________________________________________________
MS Sql Server LazyDBA home page