June 23, 2003 at 6:23 am
I have one old production server running MSSQL 7.00.1063 (STD Edition. Over the weekend I updated the IE to vrs. 6 sp1 now select DTS packages that ran flawlessly are giving the following error...SQLDMO Bulk copy Execution failed. Also the connection password information is not saved ??? Please this is a production (hahaha) system any help will be appriciated !
Jim Babington
Jbabington
Jbabington@hotmail.com
June 23, 2003 at 10:49 am
Different MDAC maybe. Got the error logging turned on? Might be worth a call to MS if you're in a hurry.
Andy
June 23, 2003 at 4:44 pm
found the issue... one of our NT Admins decided to install Veritas Backup Exec 9.0 which also installs MDAC 2.62(2.62.7926.1) noticed appriciable performance loss and the fact that DTS-Transfer SQL Server Objects fails to maintain the Users password information.. looks as if I will need to either roll back the MDAC or consider the MDAC 2.71 update. Sorry to be so wordy but also Veritas installs MSDE 2000 <thus the MDAC update> wonder if there are other issues ?
Thanks Andy for the response..
Jim Babington
Jbabington
Jbabington@hotmail.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply