Hi Darren,

I have been trying since two days to look at your reply
for my question. But due to some reason, it says the
message is unavailable. Can you please post it once again.

Thanks,

Hardly worth the wait...



Simplest way to do this is to use a SQL Agent job. Use a SQL command
called from ASP to start the job.


--
Darren Green
http://www.sqldts.com



"Rabbani" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thanks for your reply. I am new to dts. I will be very
thankful to you if you can please provide an example.

Thanks

In article <0a9501c39727$1332c940$a601280a (AT) phx (DOT) gbl>, Rabbani
<anonymous (AT) discussions (DOT) microsoft.com> writes
First of create your package.

Next right-click the package and select the Schedule option. Accept the
defaults.

Now navigate to the SQL Server Agent Jobs, and open the job your just
created above. The name of the job is the name of the package. Delete
the job schedule since you won't need it.


Now in ASP just use a regular ADO connection to connect to your DB and
execute the sp_start_job stored procedure, passing the name of the job.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org