Let's see how many different ways we can execute an SSIS package in:?
1. Using Dtexec utility from command prompt or DOS prompt
2. Using Dtexec utility from powershell or DOS prompt
3. Using DtexecUI also known as Execute Package Utility
4. Using code (C# or VB.Net)
5. Using a batch file and schedult it through Task scheduler
6. Using sp_start_job procedure to execute a sql agent job
7. Using xp_cmdshell to execute a package deployed in MSDB database or from File System
8. Using BIDS
9. Using SQL Agent job
To know how to use all of the aforesaid execution modes, please check my blog
Hi Nitesh,
ReplyDeleteThats a good post. I was thinking of doing the same. However you could just add a line about each method, it would be more helpful.
Sure Sudeep....I would love to add how-to's about all the methods. Appreciate your feedback!!!
ReplyDeleteHi Nitesh,
ReplyDeleteCould I have ur mail ID so that we can just be in touch.
nitesh.rai@gmail.com
ReplyDeleteSudeep, I have added how-to's about all the execution modes. Thanks again for your feedback
ReplyDelete