?
Solved

How to schedule DTS package in SQL 2005

Posted on 2008-10-06
3
Medium Priority
?
3,004 Views
Last Modified: 2012-05-05
hi
i have a dts package that ive migrated over to SQL 2005 and use it via the legacy section.

But id like to schedule it via SQL Agent in 2005.

Ive looked at the normal way you could schedule a job through the DTS package but of course think this is not possible via SQL 2005

Is there a way to do it ?
0
Comment
Question by:mooriginal
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 43

Expert Comment

by:Eugene Z
ID: 22652790
0
 

Author Comment

by:mooriginal
ID: 22657610
Hi thanks

Im not sure this will work
The server is only SQL 2005.
The DTS package was imported into SQL 2005 and runs in the legacy section of SQL 2005.

Your article mentions this is a tool with service pack for SQL 2k.
0
 
LVL 43

Accepted Solution

by:
Eugene Z earned 750 total points
ID: 22657925
<Im not sure this will work >
it is what used by 100s DBAs - > create sql agent job -> create step ->
read
dtsrun
http://msdn.microsoft.com/en-us/library/aa224467(SQL.80).aspx 

test something like below code in SSMS: - and then copy it into step -> schedule the job -> run (if it is ok) -post result

declare      @Cmd                  varchar (200)
select      @Cmd = 'dtsrun /Syourservername /E  /NyourDTSpackName'
exec      master..xp_cmdshell @Cmd
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question