I took the moment posted the session I’ll be presenting at the Orlando Code Camp 2012 on Saturday March 31. In this session I’ll be covering PowerShell, XML, Visual Studio Application, and integration these technologies in SQL Server Integration Services. I’ll be reusing an existing Powershell script in a SSIS Script Task component.
This session is full sample: XML files, PowerShell scripts, VB/C# code for both Visual Studio and SSIS Script Task showing some basic techniques.
For those attending this event, I hope to see you at my session.
For many years, I’ve been a PowerShell enthusiast exposed to Network
Infrastructure and SQL Server technologies. Now I’ve become a BizTalk
newbie. And, with my responsibility as a BizTalk Developer, and I attended a BizTalk Server class online. For my surprise, in one of the modules, instructor talked about a PowerShell Shell script . I just hope the script hasn’t scare anyone attending the course.
PowerShell is much easier, and fun work once you start using it. Try to ignore using cmd.exe, and start using PowerShell. Try it!! For example try to execute the BTStask.exe command.
The following sample will save the output console results to a PowerShell variable:
And, there’s more codeplex BizTalk project out there. Also, there’s some very thorough BizTalk Training Kits available from Microsoft, include Videos, Labs, and Virtual machines. But you will to use Microsoft Hyper-V Virtualization Technology:
So, in my case I use my laptop with Windows 8 Server w/Hyper-V 3.0 and it works GREAT!!
Now, I’m used to work with SQL Server so it makes sanse to me to explore the possibilities of using PowerShell to help with my BizTalk Administration. So, I can check for my Biztalk table in my SQL Server local instance in the following way:
## – Listing your local Databases:
$MySQL = New-Object(‘Microsoft.SqlServer.Management.SMO.Server’)
$MySQL.Databases | Select Name, owner, Size | Ft -auto
Also, I could list all my SQL Agent jobs with the following generic PowerShell script:
As you can see, these little simple oneliners you can give lots of information about your Biztalk box. This is all executed on your box which might bring the question: Can I do execute PowerShell script in another BizTalk box? And the answer is: YES!! But it all depends if your IT organization will allow it.
Keep in mind, you need to have the proper permissions to allow you to access these SQL server box. In the meantime, if you have your on Virtual Machine, at least you can practice show management how they can benefit from using PowerShell.