It was only a matter of time till the complete Microsoft on-premise Business Intelligence stack was moved to the Azure Paas service. With the introduction of Azure Data Factory (ADF) back in 2015 and the recent launch of ADF V2 which is in public preview for the moment, it is now possible to orchestrate complex hybrid ETL/ELT operations in the cloud. 341 more words
Tags » SSIS
#0412 - SQL Server - SSIS - Error - The value type (__ComObject) can only be converted to variables of type Object. Variables may not change type during execution.
Recently, we were manipulating a string in an “Execute SQL” task inside a SSIS package, when we ran into the following sequence of errors.
Error: The value type (__ComObject) can only be converted to variables of type Object. 437 more words
One of the several limitations comes with the excel driver is the number of columns you can import, you will find that excel only reads the first 381 more words
Issue – How to export .dtsx file from SSISDB as from SQL 2012 onward you will not see .dtsx package listed in integration services.
Note – This is shortcut solution. 67 more words