Monthly Archives: June 2012

Publish to SSIS Catalog using PowerShell

Here is a PowerShell script that I use to provision and setup SSIS Catalogs when I’m demoing SQL Server 2012. It does the following: Connects to localhost (default instance) Drops the existing SSIS Catalog Creates a new SSIS Catalog Creates a Folder Deploys a Project Creates an Environment Creates three server varaibles Creates an environment … Continued

TechEd and the SQL Server 2012 Virtual Labs

TechEd and the SQL Server 2012 Virtual Labs

I had a fantastic time at TechEd North America this year. I didn’t get a chance to attend many sessions, but thankfully they are all recorded – I usually spend a couple of weeks after TechEd crawling through all of the content I didn’t have time to see when I was there. While at the … Continued

PASS Summit 2012 – SSIS Pre-Conference Event

PASS Summit 2012 – SSIS Pre-Conference Event

Well, I guess Andy, Tim & I did a good job at PASS last year, as we’ve been invited back to present another SSIS pre-conference event at the 2012 PASS Summit. This time we’ll be joined by the co-authors of our SSIS Design Patterns book, Jessica Moss and Michelle Ufford.   SSIS Design Patterns Speaker(s): … Continued

Should I use the SQL Server Destination?

Short answer: No. Long answer: Noooooooooooooooooooooooooooooooooooooooooooooooooo. UPDATE: I was told that some people would like an explanation instead of blindly trusting my advice (weird), so here goes: In SQL 2005 RTM, the SQL Server Destination was the fastest way to load data into SQL Server with SSIS. Somewhere along the way (in the 2005 SP2 … Continued

SSIS & EIM Talks From TechEd North America 2012 Now Available

The recordings of my the SSIS sessions I presented at TechEd North America 2012 are now available online. Incremental ETL Using CDC for SQL and Oracle with SQL Server Integration Services (SSIS) 2012 Enterprise Information Management (EIM): Bringing Together SSIS, DQS, and MDS