Schedule SSIS package as Job

[ptheriault]

Ok, I've got this great book on SSIS and I've created my first SSIS package which is a simple import of data from an Oracle db. Now I want to schedule this package to run once a month as a SQL Job. How do I do that? I can't find it in my book.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[ptheriault]

Never Mind! : )

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[Catadmin]

Make sure you test this. There are some funny things that happen if you don't set it up correctly.

Such as not using the correct config information or not running at all even though the job says it succeeded.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"