Category Archives: SSIS

Can you run PowerShell in SQL Server Management Studio? YES!

Just to be clear!! You can run PowerShell in SQL Server Management Studio. Not only you can run PowerShell, but you can create scheduled jobs in SQL Agent to run PowerShell scripts. This has been available since SQL Server 2008 … Continue reading

Posted in PowerShell, SQL Server, SSIS, Windows 10, Windows 2012 | Comments Off on Can you run PowerShell in SQL Server Management Studio? YES!

Florida PowerShell Upcoming activities for May and June 2016

It’s a busy and a good time to learn some PowerShell. 1. Where: Florida PowerShell User Group Monthly meeting, Date: Thursday, May 26th at 6:30pm. Online Topic: The Essential PowerShell on Error Trapping. Description: Do you to learn how to … Continue reading

Posted in PowerShell, SQL Server, SSIS | Comments Off on Florida PowerShell Upcoming activities for May and June 2016

PowerShell in South SQL Saturday 379 was a Great Success

Once again I’m thankful to the organizers to have me speak at this “Awesome” event.  I appreciate the all whom attend my session meking it a Great Success and they got more.  My “PowerShell with Visual Studio SQL Data Tools” … Continue reading

Posted in PowerShell, SQL Server, SSIS, XML | Comments Off on PowerShell in South SQL Saturday 379 was a Great Success

IT Palooza South Florida Great Success – PowerShell Rules!

Great event on 12/12/2013 in South Florida with most IT Community User Groups showcasing their stuff. It was full of people and friends. Thanks to Nova Southeastern University and organizers (specially Alex Funkhouser) for having me as a speaker present … Continue reading

Posted in PowerShell, Resources, SQL Server, SSIS | Comments Off on IT Palooza South Florida Great Success – PowerShell Rules!

Nice DOTNETZIP Integration with PowerShell

Let me share a script I built two years ago, and I just created a function for it named “New-ZipFile“. Basically, this PowerShell function script will create a blank zipped file and copy the files to it. At the same … Continue reading

Posted in PowerShell, SQL Server, SSIS, Windows 8 | Leave a comment

Great PowerShell sessions at SQLSaturday SoFla on June 29th 2013

Yes! On Saturday June 29th, I’ll be presenting two interesting PowerShell sessions: 1. DBA Track – PowerShell Working with XML 2. SSIS Track – Integrating PowerShell in a ScriptTask component These session come full of demos and reference information.  The … Continue reading

Posted in Events, PowerShell, Resources, SQL Server, SSIS, XML | Comments Off on Great PowerShell sessions at SQLSaturday SoFla on June 29th 2013