Loading presentation...

Present Remotely

Send the link below via email or IM


Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.


Manage your ETL Framework with PowerShell

No description

Shannon Lowder

on 3 June 2014

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Manage your ETL Framework with PowerShell

Manage your ETL Framework with PowerShell
Set up your POSH Dev Environment
SQL Server
2008R2 or later
2012 (plus BI Tools)
Get PowerGUI
Make sure your PSModulePath is G2G
Our Demo ETL Framework
AdventureWorks Database
SSDT 2012 Integration Services project
1 export package
1 import Package
1 transform package
1 load package
My Project: http://tinyurl.com/ldfrmoo
Now Explore with SQLPSX!
Explore the SSIS Object
Explore Variables
Explore Executables
Can we use this to automate testing?
Where are you wasting time?
What could you automate?
What am I working on next?
Shannon Lowder
Full transcript