HI, I've written a lengthy asp page in VB to transfer files from one database to another. Can anyone tell me how I can take the content of this page and make it into a DTS package?<BR><BR>TIA
with difficulty i'm guessing. What are you trying to achieve? If you just want your script to run to a schedule just set it as a service or use a trigger to start it.
Okay, that might work too. I've heard that running an asp page is much much slower than running a DTS package or a Stored procedure. But, your idea solves my situation too. How do I set it as a service or use a trigger to start it?
Good old MS wizards....<BR><BR>In SQL Server Enterprise Manager, navigate to your db server, then click the tools menu bar, then 'job scheduling. Just follow the wizard.