E
ebhdev
Guest
Has anyone used SQL CLR as an alternative to SSIS to perform incremental loads of the Data Warehouse database. We are planning on using SQL Server Change Tracking to track changes on the source database. I was thinking that, using a SQL CLR Stored procedure located in the Warehouse Database, a connection could be established to 'Pull' changes from the source nightly and apply them to the Warehouse Database. If the CLR Stored procedure is located within the Warehouse Database, I would think the performance would be good.
Most of the developers on the team do not know SSIS and I just was not sure about introducing the complexity unless its needed. But I wanted to see if anyone has run into any issues with using just SQL CLR for ETL.
Continue reading...
Most of the developers on the team do not know SSIS and I just was not sure about introducing the complexity unless its needed. But I wanted to see if anyone has run into any issues with using just SQL CLR for ETL.
Continue reading...