There are times you may want to deploy or copy SSIS package from one server to another. Here is a quick and easy way of copying it over using command line.
Author: solutionadmin
Easiest way to move SQL Agent Job to another server
I have learned that it is not always about “doing it yourself” rather it is about – “has anyone already solved the problem” or is there an easier of doing things. In most cases there always is someone who has done it before. While, I was working on automating a…
Monitoring SQL Servers
I have only been a DBA (database administrator) for a while now. One thing Brent Ozar recommends in his training’s is knowing your inventory. I didn’t realize how important it was until I started patching servers. What I realized it is very easy to get lost in amount of information…
Exporting SQL Query Results from SSMS to CSV
Sometimes you may have large amount of data you want to export to csv file without having to leave SSMS. For this you can use bcp but you will have to make sure that you have bcp installed. To check if you have BCP installed simple open command line and…
Powershell Function to send email
I often write, powershell scripts to either run in background or run via sql job. In either case, I sometimes like to have some sort of email notification send out either on success or failure. Powershell allows you to send email from within the code. Even thought it is usually…