Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
clinton_eg
Yak Posting Veteran
60 Posts |
 Posted - 2009-06-17 : 10:17:26
|
| HiI have installed SQL 2005 on another system and have learnt how to create an SISS package.However im not sure how to schedule a package if i want to. Could any one please help.ThanksEwan Gilby |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-17 : 10:21:45
|
| you need to create a sql agent job to call and execute the ssis package and then schedule it according to your convenience |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-17 : 10:25:28
|
| also seehttp://decipherinfosys.wordpress.com/2008/09/17/scheduling-ssis-packages-with-sql-server-agent/ |
|
|
|
clinton_eg
Yak Posting Veteran
60 Posts |
Posted - 2009-07-29 : 05:19:21
|
I have created a JOB and have scheduled the package. Work absolutely fine.  I have come accross another challenge when using the Integrated SISS package. Im trying to add an Email task which will send a mail when the package is run successfully. However im not aware of my company's SMTP address (My company uses Microsoft Exchange Server). Is there no other way to add an Email task. (For SQL 2000 only add the task and the email ID's, and this used to work. I did not have to add the SMTP add details). Please could you helpEwan Gilby |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-30 : 14:09:32
|
| you can add sent mail task. but you need to have a valid email profile setup for that |
|
|
|
clinton_eg
Yak Posting Veteran
60 Posts |
Posted - 2009-07-31 : 02:47:29
|
Hi VisakhI have an office email profile set up, however not sure how to configure this in the SISS Package. When ai add a send mail task i am asked to enter the SMTP address (Which i am not aware of  ). So wanted to know if there is any other way to configure the same. (Is there no way that SQL automatically picks up the email settings from MS Outlook 2007.Thanks for your help..Ewan Gilby |
|
|
|
|
|
|
How to Schedule an SSIS Package in SQL 2005