Showing posts with label SSIS. Show all posts
Showing posts with label SSIS. Show all posts
Friday, February 7, 2025

SSIS: REPLACENULL does not support (DT_DBTIMESTAMP2,7)

›
 Using the " REPLACENULL " functionality frequently in the "Derived Column" component, the "Conditional Split"...
Thursday, January 30, 2025

SSIS warning message about SSAS Cube processing: "Operation completed with XXX problems logged"

›
If you process SSAS cubes via SSIS packages you might notice a weird message like " Full Processing:Warning: Server: Operation complete...
Friday, July 19, 2019

SSIS Data Profiling of Multiple data sets in multiple databases

›
      I assume you hit my post because you are already know how to do SSIS Data Profiling for a single table, but now you want to know how t...
5 comments:
Wednesday, July 17, 2019

SSIS Data Profiling Bug uncovered by SQL Server glitch

›
I was doing Data Profiling in my environment using SSIS and hit very unusual error: SSIS package "Package 2.dtsx" starting. Er...
Sunday, July 22, 2018

SSIS Script Task:Error: The Script Task is corrupted.

›
There are probably a lot of SSIS corruption errors, but that is one that is very easy to solve. The whole error message is texted like th...
6 comments:
Saturday, July 16, 2016

Connect to SSIS when "The RPC server is unavailable"

›
Recently tried to connect to Remote SQL Server Integration Service directly from SSMS and got following error: TITLE: Connect to Serve...
5 comments: