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

N2ITN2IT Posts: 7,483Inactive Imported Users
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.

Comments

  • RobertKaucherRobertKaucher Posts: 4,298Registered Members
    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.
  • N2ITN2IT Posts: 7,483Inactive Imported Users
    Thanks Robert!
Sign In or Register to comment.