dbTalk Databases Forums  

open package in Enterprise manager gives error

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss open package in Enterprise manager gives error in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
SainathK
 
Posts: n/a

Default open package in Enterprise manager gives error - 09-22-2006 , 09:34 AM






I had created a DTS package which contains a single activeX script task. To
this DTS package, I pass the complete connection string via a .bat file. I
generated the command line for it using DTSRunUi tool.

The activeX script opens a connection, truncates 2 tables, imports data and
then runs a stored procedure.

I was able to successfully save and run the DTS. But now when I try to use
the "Open Package" functionality from enterprise manager, I get the error:
code execution exception: EXCEPTION_ACCESS_VIOLATION

I am unable to open my package. I tried to do the same on two other machines
with the same result. Would appreciate it if anyone can tell me how I may
open this back in design mode?



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.