I’m excited to announce the availability of SSIS Premium, a training offering focused solely on SQL Server Integration Services (SSIS) recorded training. Learn more about each offered course at the following links: From Zero to SSIS – four days of recorded training, includes labs. Master the SSIS Catalog – a day of SSIS Catalog recorded …
Continue reading Announcing SSIS Premium Training
Tag:SSIS Performance
OLE DB is *NOT* Deprecated
I cannot count how many times I’ve been asked about the deprecation of Microsoft OLE DB for SQL Server. My best guess? Hundreds of times over the years. My reply to questions has been: “I do not believe Microsoft will deprecate the OLE DB Driver for SQL Server.” In data integration circles, the announcement in …
Continue reading OLE DB is *NOT* Deprecated
SSIS Performance Pattern – Loading a Bajillion Records
Do you need to use SSIS to load some data from a large source? This post covers some thoughts on a couple/three patterns you may apply to help. I can hear you thinking, “Which pattern should I use, Andy?” That’s an excellent question! The answer is, “It depends.” You should test each pattern and see …
Continue reading SSIS Performance Pattern – Loading a Bajillion Records