ive created a package that's supposed to run every night. the package works fine and is now ready for deployment so ive created a deployment utility for this (is this the best way to deploy?) what i want to know is is there a way to set the package to run every night upon deployment?
Hi,
The deployment utility is a fine way to deploy packages, but you have to take the next step to setup a job manually.
|||Use SQL Server Agent to schedule your job.If deploying to the file system, you don't need a deployment utility -- you can just copy the .dtsx and any configuration files over to the file system.
Phil
No comments:
Post a Comment