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
Native SAP SuccessFactors and Active Directory Connectivity for Simplified Data Integration
Having native connectors for SAP SuccessFactors and Active Directory would eliminate the need for workarounds such as notebooks, custom scripts, or complex integration setups. Users should be able...João_Cristo33 minutes agoNew MemberNew2Views0likes0CommentsAllow Azure Databricks streaming tables to be mirrored into Fabric
Mirroring an Azure Databricks Unity Catalog into Fabric silently drops streaming tables. They are not greyed out, not flagged, not explained. They simply do not appear in the picker, so there is no w..._taab1 hour agoNew MemberNew5Views0likes0CommentsPower BI, import report and semantic model: show change connection pop-up
When you need to import an existing Power BI report and semantic model in Tenant B that's created in Tenant A, you need to jump through a number of hoops to fix the original connection. It's doable, ...Reitse3 hours agoMost Valuable ProfessionalNew7Views1like0CommentsEnable per-user security for shared gateway connections using service accounts
When a shared gateway connection uses a highly privileged service account, all source queries run with that account’s permissions. Users cannot see the stored credentials, but report developers who c...AshishChougala3 hours agoMicrosoft EmployeeNew14Views6likes0CommentsRequest to add a feature to extract gateway connection status and last time credentials used
Could you please add a feature in the admin UI on Microsoft Fabric/Power BI to extract the Gateway connections with details of the gateway connection status and last activity information along with t...Vinodkumar_Chak4 hours agoNew MemberNew23Views1like0Comments