dbTalk Databases Forums  

Error Scheduling a DTS Package

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


Discuss Error Scheduling a DTS Package in the microsoft.public.sqlserver.dts forum.



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

Default Error Scheduling a DTS Package - 09-07-2004 , 08:20 PM






Hello There,

what is the best methodology to schedule a DTS package,
the one i used is simply right-clicking on the dts
package, select scheduling and that's it.

I have one package that fails with error "Not Implemented",
I read the article suggested from Allan, but I do not
think is applicable for my case.

The package i am trying to schedule has couple of ActiveX
scripts to check for file exists, and couple of
ExecutePackageTask, and that's it not complex at all.

Any suggestions are really appreciated.

thanks



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

Default Re: Error Scheduling a DTS Package - 09-08-2004 , 12:07 AM






To chedule a package I build the job myself then use DTSRUN as the syntax

You can generate the correct syntax for this through DTSUNUI. (Start | Run)

It does sound as though something you are using in the package is not
available on the scheduling SQL Server though.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"martino" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hello There,

what is the best methodology to schedule a DTS package,
the one i used is simply right-clicking on the dts
package, select scheduling and that's it.

I have one package that fails with error "Not Implemented",
I read the article suggested from Allan, but I do not
think is applicable for my case.

The package i am trying to schedule has couple of ActiveX
scripts to check for file exists, and couple of
ExecutePackageTask, and that's it not complex at all.

Any suggestions are really appreciated.

thanks





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.