SSIS is laking some basic features, third party vendors complete the existing toolbox, but such components should have been integrated in SSIS for a long time. I'm thinking about a proper UPDATE or UPSERT task (instead of the OLEDB parameters passing nightmare), a revisited SCD destination which could offer good performances, a SMTP task with higher configuration options, etc...
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Dedicated Fabric Message Center to communicate planned Fabric Changes
Summary Microsoft recently rolled out a change that automatically enabled the Item Recovery tenant setting in Microsoft Fabric for tenants where the setting had not been explicitly configured. Accor...Edgar_10 hours agoNew MemberNew33Views5likes0CommentsWorkspace-Level Control of Storage Modes (Import vs DirectQuery vs Direct Lake)
Organizations operating under strict governance and data residency requirements need the ability to control which storage modes are permitted within a workspace. Currently, report authors can choose...masoodaftab10 hours agoNew MemberNew6Views0likes0CommentsGranular Workspace Permissions Beyond Workspace Roles
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } The current workspace access model is limited to the predefined workspac...masooddevcorp11 hours agoNew MemberNew19Views1like0Comments