https://alexanderdevelopment.net/tag/ssis/Recent content in ssis on Alexander DevelopmentHugo -- gohugo.ioen-usThu, 08 Feb 2018 19:01:01 +0000https://alexanderdevelopment.net/post/2018/02/08/disable-enable-dynamics-365-ce-users-with-ssis-kingswaysoft/Thu, 08 Feb 2018 19:01:01 +0000https://alexanderdevelopment.net/post/2018/02/08/disable-enable-dynamics-365-ce-users-with-ssis-kingswaysoft/Recently I was asked to set up a process to automatically disable or re-enable Dynamics 365 Customer Engagement users depending on some external data. This ended up being ridiculously easy to do with SSIS and KingswaySoft’s Dynamics 365 Integration Toolkit. Let me show you how it works. In Dynamics 365 CE, you can disable or enable a user record just by setting the value of its “isdisabled” attribute to true or false, so both my disable user data flow and re-enable user data flow do roughly the same thing.https://alexanderdevelopment.net/post/2017/06/23/another-approach-to-complex-dynamics-365-text-interfaces-using-kingswaysoft-and-xslt/Fri, 23 Jun 2017 17:30:00 +0000https://alexanderdevelopment.net/post/2017/06/23/another-approach-to-complex-dynamics-365-text-interfaces-using-kingswaysoft-and-xslt/Last week I posted an approach for generating complex text files from Dynamics 365 with KingswaySoft and XSLT that uses a custom script component to apply an XSL transformation to an XML document generated with the the SSIS XML merge component from the KingswaySoft SSIS productivity pack. After I shared that post, Daniel Cai at KingswaySoft told me the premium derived column component in the SSIS productivity pack can also be used to apply the XSL transformation.https://alexanderdevelopment.net/post/2017/06/15/generating-complex-text-files-with-kingswaysoft-and-xslt/Thu, 15 Jun 2017 12:00:00 +0000https://alexanderdevelopment.net/post/2017/06/15/generating-complex-text-files-with-kingswaysoft-and-xslt/Recently I needed to build an SSIS package that would generate a delimited text file with multiple sets of related (but different entity) Dynamics 365 records combined in a single grouping. Each record would be on a separate row (with different formats for each record type), and each grouping of related records would have its own header and trailer rows.https://alexanderdevelopment.net/post/2017/06/13/real-time-dynamics-365-data-integrations-with-ssis-kingswaysoft/Tue, 13 Jun 2017 12:00:00 +0000https://alexanderdevelopment.net/post/2017/06/13/real-time-dynamics-365-data-integrations-with-ssis-kingswaysoft/I’m a big fan of KingswaySoft’s Dynamics 365 SSIS integration toolkit for moving data between Dynamics 365 and other systems. Because the integrations are run in SSIS packages, there’s a lot of power and flexibility, and you can use SQL Server Agent to orchestrate your integration jobs. This is great for scheduled jobs, but what do you do if you need to trigger a job based on activity in Dynamics 365?https://alexanderdevelopment.net/post/2015/11/02/ssis-package-for-moving-access-team-templates-with-kingswaysoft/Mon, 02 Nov 2015 03:13:14 +0000https://alexanderdevelopment.net/post/2015/11/02/ssis-package-for-moving-access-team-templates-with-kingswaysoft/Last year Ben Hosking said there was no way to move access teams between Dynamics CRM organizations, so I created a tool to do that. Last month Tanguy Touzard said I should turn my console application into an XrmToolBox plugin, so I did. Soon after that Daniel Cai said I should make something with the KingswaySoft SSIS Integration Toolkit, so I’ve now written a version of my access team template mover as an SSIS package.