Solved

How to schedule DTS package in SQL 2005

Posted on 2008-10-06
3
3,000 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 250 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

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

717 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