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
Allow us to rename fabric data agents published to m365
If we use deployment pipelines to promote fabric data agents between dev, test/UAT, and prod fabric workspaces, we need to keep the name of the fabric agent the same in each workspace. If we want to ...PeterDaniels6 hours agoAdvocate IIINew183Views0likes2CommentsMake workspace and item session persistence optional
Description The new persistent session behavior in Microsoft Fabric should be optional rather than forced. Currently, Fabric remembers the workspaces and items that were open in my previous session...TeemuMultanen7 hours agoAdvocate INew294Views47likes2CommentsSupport Encrypted Sensitivity-Labeled Excel Files in Power Query
Description Currently, Power Query Online and Power Query in Excel are unable to access encrypted Excel files. Excel files with sensitivity types other than Public or Non-Business can be encrypted a...ewarstdhyjugkhi7 hours agoMicrosoft EmployeeNew22Views6likes0Comments