Ed/Margaret: In SQL2K I create a job to run an Operating System Command
with the following command:

DTSRun /S "PUT SERVER NAME HERE" /N "PUT PACKAGE NAME HERE" /W "0" /E

The trailing arguments are:
/W Windows_Event_Log (Specifies whether or not to write the completion
status of the package execution to the Windows Application Log. Specify
True or False.)
/E Specifies a trusted connection (password not required).

I haven't had a need to try it in SQL2K5 yet, but it wouldn't hurt to
give it a try.

No trees were killed in the making of this email. However, a large
number of electrons were diverted from their original destination.

-----Original Message-----
From: Edwards Ed
[mailto:mssqldba-ezmlmshield-x91091064.[Email address protected]
Sent: Friday, June 29, 2007 12:04 PM
To: LazyDBA Discussion
Subject: RE: SQL2005 DTS schedule legacy job

Now, Margaret!
If you didn't have a SQL Server Agent Job, and you want to run a SSIS
Job (formerly DTS), you have to download the DTS 2000 Designer add-in.





Please take a few minutes to provide feedback on the quality of service
you received from our staff. The Department of Education values your
feedback as a customer. Commissioner of Education Jeanine Blomberg is
committed to continuously assessing and improving the level and quality
of services provided to you.Simply use the link below. Thank you in
advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Norkett Margaret
[mailto:mssqldba-ezmlmshield-x23358098.[Email address protected]
Sent: Friday, June 29, 2007 1:41 PM
To: LazyDBA Discussion
Subject: SQL2005 DTS schedule legacy job

I've pulled over a DTS job from my old SQL server to my SQL2005 server
and it's put it into the Legacy folder. When I go to try to create a
scheduled job to run it, Legacy is not one of my choices.



How do I create a job to schedule my legacy DTS to run or will I have to
re-create the job in SSIS?



If you have any questions or concerns, please let me know them.



Margaret Norkett

Database Administrator

* 864-271-6522 ext 222

* 864-270-2884









The thing always happens that you really believe in; and the belief in a
thing makes it happen.

Frank Lloyd <http://www.quotationspage.com/quotes/Frank_Lloyd_Wright/>
Wright
US architect (1869 - 1959)





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page