Loading presentation...
Prezi is an interactive zooming presentation

Present Remotely

Send the link below via email or IM

Copy

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.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Manage your ETL Framework with PowerShell

No description
by

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
SSDT
2012 (plus BI Tools)
Get PowerGUI
http://ow.ly/sbpdo
Get SQLPSX
http://ow.ly/sbppe
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?
Conclusion
Where are you wasting time?
What could you automate?
What am I working on next?
Shannon Lowder
@shannonlowder
Full transcript