PowerObjects Blog

for Microsoft Business Applications

Featured BLOG POST

Archive for Tag: ssis

Dynamics 365

Using Flow to Create Dynamics Records using a Scheduled Flow

In this blog, we walk through how to use Microsoft Flow to create Dynamics records using a scheduled Flow.

Read More
Tips and Tricks

Uploading a File to Azure Blob from SSIS

In today's blog, we'll walk you through the steps necessary to upload a file to Azure Blob from SSIS. Enjoy! 1. Open Visual Studio > New Project > Integration Services Project and click to create a new Integration Services Project. Rename the newly-created .dtsx file as needed. The initial screen will look like this: 2. […]

Read More
GUIDs
Dynamics 365

Clearing Up Some Confusion about GUIDS in Dynamics 365

There is often confusion about how GUIDs work, how unique they are, and how they are generated in CRM. Read this blog to get some better insight into GUIDs!

Read More
data
Dynamics 365

Maximizing Data Integration and Migration Performance in Dynamics 365

Data integration and migration is a challenging tasks in any Dynamics 365 implementation - in this blog we share some ways to tackle performance issues.

Read More
Dynamics 365

How to Call a Custom Action in a SSIS Integration

Here's how to call a custom action in a SSIS Integration in Dynamics 365 in order to take advantage of advanced business logic during a data import.

Read More
Tips and Tricks

Using SSIS/KingswaySoft Adapter to Obtain Audit Information

A common request we see is the ability to extract and report on audit data gathered by CRM. If you have done any work or research around this topic, you may have found that it can be tricky. Lucky for you, today's blog will help you solve this issue by teaching you how to use KingswaySoft […]

Read More
Development

Importing Created and Modified Values in CRM

When importing data into Dynamics CRM using SSIS, you also need to import your Created on/by and Modified on/by data. Previously, you could only import CreateOn fields by mapping the "overriddencreatedon" field with source data. We now have at least two supported options to update these fields, and in today's blog, we will show you […]

Read More
Tips and Tricks

Get Faster and Simpler Update/Insert Transactions Using SSIS

When you are building an integration using SSIS, chances are you will need to update or insert data that has been created or changed in the source system on a regular basis. The SSIS job must be able to identify the newly created records versus the changes to existing records and perform the updates and […]

Read More
SSIS with Net Change Pattern
Tips and Tricks

SSIS with Net Change Pattern

When you are building a bi-directional integration between CRM and an external application using SSIS, chances are you will need to send data that has been changed by a user in CRM on a regular basis. There are a couple of key challenges with this approach, given the traditional mechanism to deal with changes by […]

Read More
Retrieving SSIS project/packages from SSIS catalog in Dynamics CRM
Development

Retrieving SSIS project/packages from SSIS catalog in Dynamics CRM

If your SSIS project is deployed to SSIS catalog i.e. SSISDB and you lost your source project file, then you need to edit the SSIS packages in the deployed project. In this blog from PowerObjects, we will discuss how to retrieve your project/packages. Option 1: Integration Services Import Project Wizard Open a new project from […]

Read More
Optimizing SSIS with Microsoft Dynamics CRM
Customizing

Optimizing SSIS with Microsoft Dynamics CRM

The use of SQL Server Integration Services (SSIS) for migrating and integrating data to Dynamics CRM allows for a level of adaptability and versatility that is unmatched in the right hands. Additionally, the customizability and versatility of SSIS allows for performance tweaking and enhancements to maximize data throughput. One of the most significant methods of […]

Read More
SSIS 2012 Deployment Model and Mapping SSIS Parameters to Environment Variables
Development

SSIS 2012 Deployment Model and Mapping SSIS Parameters to Environment Variables

If you couldn't tell by the title, we're going to go beyond CRM 101 and get a little more technical in this post. Specifically, let's talk about a few important new features of SSIS 2012 that can help BI developers. SSIS 2012 introduced a new feature called Integration Services Catalogs, which means that now we […]

Read More
Optimizing SQL Integrating Services (SSIS) with MSCRM
CRM 2011

Optimizing SQL Integrating Services (SSIS) with MSCRM

Almost every CRM implementation project has a data component, whether it is migrating data from your legacy system or integrating CRM to/from another database or application. Especially integrations have become more important, the user-friendly user interface of CRM is the preferred application for users and with good integration plan the users can drive their ERP, […]

Read More
Featured BLOG POST