dbTalk Databases Forums  

Solution: Invalid STDGMEDIUM structure error in DTS package

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Solution: Invalid STDGMEDIUM structure error in DTS package in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jshunter@waikato.ac.nz
 
Posts: n/a

Default Solution: Invalid STDGMEDIUM structure error in DTS package - 10-17-2007 , 05:20 PM






This morning I got the following error from a DTS package which had
been running happily for months (we're running SQL Server 2005 (64-
bit)):

Invalid STDGMEDIUM structure error
[Microsoft][ODBC SQL Server Driver][SQL Server] Incorrectl syntax near
')'

I couldn't find the solution online, but I did figure it out myself
eventually. The problem was caused by a system table "sysdiagrams"
appearing. Apparently DTS doesn't like what it contains. Since I don't
use database diagrams, I deleted it, and the DTS package started
working again

Now if only I could get rid of those SQL-DMO errors whenever I try to
select objects in DTS...

--John Hunter


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.