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
Auto-propagate Lakehouse (Direct Lake) permissions to users assigned to a Power BI App audience
Problem When a Power BI report uses a Live Connection to a Direct Lake Semantic Model, end users must have explicit ReadAll / ReadData permissions on the underlying Lakehouse (or its SQL analytics e...majofv36 minutes agoNew MemberNew2Views1like0CommentsVisual Type Defaults in Visualization Pane
This would change my life with fussy clients and client/public facing apps. In addition, it would allow me to add more value to the clients on retainers who do not have the 'hours' to allocate to...IolaWhiteley55 minutes agoAdvocate IINew76Views7likes1CommentAdd a Close or “Return to previous page” button to Semantic Model Security and Settings pages
When updating RLS group assignments through Semantic model > Security, there is no consistent in-product Close or Done button that returns the user to the previous workspace view. The browser Back b...Kalaiselvan3 hours agoFrequent VisitorNew2Views0likes0Comments