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
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
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
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
I’ve posted the CDC demo packages and scripts from my TechEd session to my skydrive share.
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