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
SQL Analytics Endpoint host name - CNAME or defined alias
The host name for a SQL Analytics endpoint is ugly. They look like this: random_ugly_alphanumeric-random_ugly_alphanumeric.datawarehouse.fabric.microsoft.com The first segment looks like it...Mike_Diehl18 minutes agoNew MemberNew24Views2likes1CommentFix links generated in multi tenant setups
When I log into Fabric, and I have access to multiple tenants, the links generated for things like monitoring URLs in pipeline runs do not include "ctid=<tenantguid>" query string value, which appear...jwisemanfs2 hours agoNew MemberNew3Views0likes0Comments