Tags » SSIS

Introduction to Azure Data Factory V2

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

SSIS

Issues related to Oracle Client in SQL Server.

Issue –

My BI developer informed me; They are no longer able to connect oracle data sources they have created in their cube.

Troubleshooting – 436 more words

Sql Dba

#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
#SQLServer

SSIS - IMPORTING EXCEL FILE WITH OVER Than 255 COLUMNS

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

SQL Server

How Medium Voltage Switchgear Innovations Help Fight Extreme Weather

In my last post, I listed some of the aspects of extreme weather that are putting medium voltage switchgear in special service conditions affecting its ratings and lifespan. 885 more words

Technology

How to export SSIS package ( dtsx file) from SSISDB

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

SSIS

Calculating RunningTotal | Cummulative Total in SQL

Video Tutorial: Derive Running Total Field

In this above video we are goin to learn how to derive a running total / Cummulative field.

  • First field will be a straight running total for all value…
  • 266 more words
SSIS