| Author | Message | ||
     Pele Junior Artist Username: Pele Post Number: 63 Registered: 10-2008 Posted From: 94.169.50.150 Rating: N/A |
Yes it can be done.. create a package which executes the other packages in it. but care should be taken regarding the connections of other packages.. I saw one package executing other 3 packages as a part of it. | ||
| Ashton Hero Username: Ashton Post Number: 13047 Registered: 05-2008 Posted From: 205.234.140.219 Rating: N/A |
Write a Cron script. | ||
| Basky_indya Megastar Username: Basky_indya Post Number: 28715 Registered: 10-2007 Posted From: 24.127.230.2 Rating: N/A |
agent kindha chestha tammudu. but anni kakunda, main dhi schedule chesi, internal ga adhi anni packages load ayyetattu chesthey baguntundi kRUshITHO nAsthee dURbhikSHAM!! JP_ROCKS: ...der unte enchakka andarni giant wheel ekkistadu..girrr mani oogachu.. | ||
| Ntr_rocks Moderator Username: Ntr_rocks Post Number: 26223 Registered: 04-2009 Rating: N/A |
Annai nenu expert ni kaadu kani.. Windows servuce kavali lekapothe sql database lo sql server agent lo jobs kinda configure cheyali.. I did using window service as configuring under sql server agent needs admin rights.. | ||
| Maharshi Junior Artist Username: Maharshi Post Number: 970 Registered: 02-2008 Posted From: 69.248.161.188 Rating: N/A |
Anni SSIS packages ni oka stored proc nundi execute chesettu stored proc raasi and you can schedule that one stored proc. Dtexec command will be helpful in executing SSIS package from stored proc ..here is some help on how to use that : http://www.codeproject.com/KB/database/Call_SSIS_from_SP.asp x SSIS work chesi channallu ayindi ..so not 100% sure on detail level | ||
| Basky_indya Megastar Username: Basky_indya Post Number: 28712 Registered: 10-2007 Posted From: 24.127.230.2 Rating: N/A |
bump for twitter,others kRUshITHO nAsthee dURbhikSHAM!! JP_ROCKS: ...der unte enchakka andarni giant wheel ekkistadu..girrr mani oogachu.. | ||
| Basky_indya Megastar Username: Basky_indya Post Number: 28710 Registered: 10-2007 Posted From: 24.127.230.2 Rating: N/A |
Instead of having all the dtsx packages under scheduler, can we have a Wrapper Job (generic ssis batch) which will be scheduled as 1 job and internally it will be calling and executing other batches. Frequency , other db values will be driven through database table values only. Is it possible for the above scenario to be accomplished?? Hope we dont require any window-service etc to keep the wrapper job supported . we dont get permissions for SERvices etc to be run to invoke the batch. The Wrapper Job will be under Scheduler. Pls throw some light, will be able to execute all my other batches under these?? kRUshITHO nAsthee dURbhikSHAM!! JP_ROCKS: ...der unte enchakka andarni giant wheel ekkistadu..girrr mani oogachu.. |
