<div>
create step in the job and use dtsrun utility<br />
see<br />
<a href="http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=82&threadid=87776&enterthread=y" rel="ugc">http://sqlforums.windowsit<wbr />pro.com/we<wbr />b/forum/me<wbr />ssageview.<wbr />aspx?catid<wbr />=82&amp;thread<wbr />id=87776&amp;e<wbr />nterthread<wbr />=y</a> <br />
&nbsp;--<br />
dtsrun<br />
<a href="http://msdn.microsoft.com/en-us/library/aa224467(SQL.80).aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/aa224467(SQL.80).aspx</a>&nbsp;<br />

</div>


create step in the job and use dtsrun utility
see
http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=82&threadid=87776&enterthread=y [http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=82&threadid=87776&enterthread=y]
 --
dtsrun
http://msdn.microsoft.com/en-us/library/aa224467(SQL.80).aspx [http://msdn.microsoft.com/en-us/library/aa224467(SQL.80).aspx] 


<div>
Hi thanks <br />
<br />
Im not sure this will work <br />
The server is only SQL 2005.<br />
The DTS package was imported into SQL 2005 and runs in the legacy section of SQL 2005.<br />
<br />
Your article mentions this is a tool with service pack for SQL 2k.<br />

</div>


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.


<div>
<div class="content wysiwyg-content">
hi<br />
i have a dts package that ive migrated over to SQL 2005 and use it via the legacy section.<br />
<br />
But id like to schedule it via SQL Agent in 2005.<br />
<br />
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<br />
<br />
Is there a way to do it ?
</div>
</div>


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 ?

How to schedule DTS package in SQL 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.