Practical SQL Server : How to remotely execute an SSIS package. There is a lot of confusion around SSIS and how and when you can execute packages, so hopefully I can help clear this up.
If you just have the SQL Server management tools on your desktop (Management Studio and Business Intelligence Development Studio aka. BIDS) then you can build a package in BIDS and run it there, but you can’t deploy to your local machine and execute there. You need SSIS installed on a machine to execute a package. That doesn’t mean you can’t call SSIS packages from a job server that doesn’t have SQL Server on it, however.
In order to do this you need to put your SSIS package into a job on the SQL Server box. Useful Commandline Commands on Windows. 99 of the best Windows freeware programs you may not know of. Because of the popularity of my previous article on Help Desk Geek entitled 99 ways to make your computer blazingly fast, I’ve decided to write another list post with 99 items, but this time on Windows freeware programs that you may have not heard of.
If you search for “best freeware programs” or “top freeware apps”, you’ll get lots of lists, but mostly with programs everyone has already heard of: AVG anti-virus, 7-zip, Firefox, OpenOffice, etc, etc. That’s all nice and fine, but what about all those little gems programs that work great, but don’t get all the headlines? In this article, I will try my best to mention as many small name freeware programs as I can that can help make you more productive! As usual, I write for both Help Desk Geek and for Online Tech Tips, so I will be linking to old posts throughout if I’ve written about it or else I will link out to the main website for the program. These are written in no particular order!