Any recommend YouTube videos or training for setting up ETL's in Sql Server?

N2IT

I am doing that now based off of flat files, XML files and XLSX files. I was wondering if there was a good book out there that was really functional based. I really don't need training materials just a how to more less. Anyone experience a good MS SQL ETL book I would appreciate it.

RobertKaucher

The problem is really that every ETL case is so specific I don't think you are going to find anything except for blog posts on how to handle certain details like numeric conversion and datetimes. You'll find print material on how to use SSIS and things like that but that is probably it.

Here are some PluralSight cources...

Advanced Integration Services
Advanced Integration Services - Online Training Course for Developers

Optimizing OLTP and Data Warehousing with SQL Server 2014
Optimizing OLTP and Data Warehousing with SQL Server 2014 - Online Training Course for Developers

The best advice I can give you is make sure you know C# and Entity Framework, because T-SQL is excellent for certain things like merging structured data or working relationaly with sets but there are some times things need to be looped through one at a time and for that being able to split the data into batches and then process each batch on a different processor can really save you some time.

N2IT

Thanks Robert!