dbTalk Databases Forums  

Could Not Create an Instance of the DTS Package

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


Discuss Could Not Create an Instance of the DTS Package in the microsoft.public.sqlserver.dts forum.



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

Default Could Not Create an Instance of the DTS Package - 01-07-2004 , 01:17 AM






Hi

I have a customer who is running a a Job that executes a
DTS package. This had be running fine until 2 days ago
when we were told they were having problems. Every time
the job is run it Fails, When I try to execute it manually
nothing happens and then when I try to re-create the DTS
Package I get this error every time.

"Could not create an instance of the DTS Package"

Any help would be great.

Regards

Ian

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Could Not Create an Instance of the DTS Package - 01-07-2004 , 01:31 AM






Try reregistering the DTS dlls. Maybe something whacked them.

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Ian Bowden" <ianb (AT) cbitsolutions (DOT) com> wrote

Quote:
Hi

I have a customer who is running a a Job that executes a
DTS package. This had be running fine until 2 days ago
when we were told they were having problems. Every time
the job is run it Fails, When I try to execute it manually
nothing happens and then when I try to re-create the DTS
Package I get this error every time.

"Could not create an instance of the DTS Package"

Any help would be great.

Regards

Ian



Reply With Quote
  #3  
Old   
Ian Bowden
 
Posts: n/a

Default Re: Could Not Create an Instance of the DTS Package - 01-08-2004 , 11:35 PM



Thanks that worked...


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:
Try reregistering the DTS dlls. Maybe something whacked them.

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Ian Bowden" <ianb (AT) cbitsolutions (DOT) com> wrote in message
news:06ed01c3d4ee$4abc1150$a601280a (AT) phx (DOT) gbl...
Hi

I have a customer who is running a a Job that executes a
DTS package. This had be running fine until 2 days ago
when we were told they were having problems. Every time
the job is run it Fails, When I try to execute it manually
nothing happens and then when I try to re-create the DTS
Package I get this error every time.

"Could not create an instance of the DTS Package"

Any help would be great.

Regards

Ian





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.