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 |
|
Zoma
Yak Posting Veteran
76 Posts |
 Posted - 2008-06-03 : 05:15:18
|
| Hi All,I've been assigned a task by one of the programmer in my team to create packages from some of the databases(One from SQL2005&Other one from SQLEXPRESS)I've created and saved the packages using the export wizard.I saved the Packages as Integration Services Packages(On file System).Now he wants me to execute the packages using SSIS But in different time,like maybe after 5min.Other package runs.I really have no clue how to do that,I've added Both packages in SSIS,But i really dont know how to run them in different time.If anyone could help please do so! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-03 : 16:35:07
|
| You can run packages as scheduled sql jobs, read books online on how to create sql job. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-03 : 23:54:50
|
| Refer this too:-http://msdn.microsoft.com/en-us/library/ms139805.aspx |
|
|
|
Zoma
Yak Posting Veteran
76 Posts |
Posted - 2008-06-10 : 08:15:17
|
| Thanks it worked i created a sql job to run the SSIS Packages.Thanks a lot!!! But though my managers are'nt happy with it,But i've figured out some other way! |
|
|
|
|
|
|
Executing Different SSIS Packages