Solved

How to schedule DTS package in SQL 2005

Posted on 2008-10-06
3
2,988 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
  • 2
3 Comments
 
LVL 42

Expert Comment

by:EugeneZ
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 42

Accepted Solution

by:
EugeneZ 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
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 extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

786 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