executing DTS packages programatically

<i><b>Originally posted by : Gregory Lybanon (greg@twinengines.com)</b></i><br />Is it possible to run a DTS package from ASP or a stored procedure?<br /><br />I am trying to automate updating a database. The database comes to me as an Access database and I would like to use a simple DTS package to migrate the data over to a SQL Server database.<br /><br />I know that ADODB.Command will allow me to execute SQL and to run a stored proceedure, but it doesn't look like there's a method for executing a DTS. <br />

<i><b>Originally posted by : Lee Brandt (lbrandt@intertec.com)</b></i><br />There is a DTS.Package object<br /><br />Set objPackage = Server.CreateObject("DTS.Package")<br /><br />Then you can look through the methods and properties.<br /><br /><br />------------<br />Gregory Lybanon at 8/9/2000 4:20:35 PM<br /><br />Is it possible to run a DTS package from ASP or a stored procedure?<br /><br />I am trying to automate updating a database. The database comes to me as an Access database and I would like to use a simple DTS package to migrate the data over to a SQL Server database.<br /><br />I know that ADODB.Command will allow me to execute SQL and to run a stored proceedure, but it doesn't look like there's a method for executing a DTS. <br />