Solved

How to schedule DTS package in SQL 2005

Posted on 2008-10-06
3
2,987 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Parse field in SQL View 15 96
triggered use of sp_send_dbmail failure 2 22
What is format f12.8 for a CSV file 6 37
My Query is not giving correct result. Please help 5 27
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

932 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now