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 |
|
mauler05
Starting Member
17 Posts |
 Posted - 2007-11-19 : 14:51:54
|
| Is there a way to trigger a SSIS package automatically when it ends successfully. Actually i am moving data from one database to other.......i am passing start date and end date as my paramter...So is there some way once my SSIS package ends succesfully then it can start again on its own reading a new set of date range from a file or something....I appreciate any reposne in advanceThanks... |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-11-19 : 16:41:22
|
| You sound want to make it loop back to step one. Interesting...Normally, you should use sql agent to schedule a job. Another possibiity is to custom build a controling app that will provide the business logic. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-11-20 : 08:56:08
|
| As you are passing in the values rather than rading them in the package it sounds like you want to code a loop calling dtexec to run the package.You could do this in an sp or vbscript or whatever you like. You could code it in a package which might make the implementation easier.Another option is to read the values from within the package - then it's just a matter of repeatedly calling it. Easiest is to create a scheduled job that runs every minute - that will also give a record of when it runs.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Trigger a SSIS package on its completion...