We might get this error while trying to access a ReadWrite variable within Script Component outside Post Execute.
Here we were using it within ProcessInputRow method
As per the official documentation – the reason for this error is because ReadWriteVariables are only available inside PostExecute method for improved performance and minimizing locking.
Updating the code to use PostExecute method fixed the issue for us.
Hope it helps..
overriddencreatedon
While working in data migration project, when creating records in the target system, we would want the “created on” field to hold the original value instead of it being set to the actual value when it was created in the target system, which is set by the system or the platform itself.
Suppose we are having the “created on” field in our source SQL Server Table and we are creating the lead records in our target Dynamics 365 organization using KingswaySoft’s CRM Destination Component.
Here we have mapped the CreatedDate of our source table to overrriddecnreatedon field of Lead entity.
On executing the package, back inside Dynamics 365, we can see the following values for Created On and Record Created On (overrriddecnreatedon) field for the lead records.
Record created on will have the time when the record was created in Dynamics 365 and Created On field will have the values that we passed from our source SQL Table.
Get all the details here
Hope it helps..
SSIS has various data flow transformation components that make it easy to manipulate the source data before it can be sent to the destination for processing.
Below are some of the most frequently used one
For changing the data type of the source column.
Simply select the input column and then specify the data type for it.
For e.g., if our source has one of the date columns as a string, we can apply Data Conversion transformation to convert its data type to Date.
Can be used if we want to apply the expression to the source column and create a new column or update the existing column.
For e.g. we are interested in the Year part of the Modified Date column. For this we can use the Year Date/Time function, get the year part and add it as a new column.
To reduce the number of rows in the pipeline.
Percentage Sampling allows us to define the percentage of rows for sampling. It generates two output, one output for the rows that are selected and the other for the unselected.
Similarly, Rows Sampling allows us to specify the number of rows directly instead of a percentage. It also gives the option to select the columns.
Multicast can be used to pass the same data to multiple destination as shown below.
Sort transformation can be used to specify sorting for the data. In the case of SQL, we can specify sort in the query itself however in case of working with flat files, this function can be handy.
To perform aggregation on the source data we can use Aggregation transformation.
Union All allows us to combine data from multiple sources. Here the column structure should be identical of the sources. The data from the first source is passed to the destination, followed by the data from the second.
We’d covered some of the common transformation components in this post, in the next post we’d try to cover the remaining frequently used transformation.
Hope it helps..
Prior to D365 V9, we were using Xrm.Utility.openWebResource() to open a web resource in a new window. However, going forward in D365 V9 we need to use Xrm.Navigation.openWebResource() to perform the same operation. Let’s take an example:
D365 V8:
D365 V9:
Hope it helps !!
Suppose a package has been running for quite a long time or has been mistakenly run and we would like to stop its execution.
To do so
Exec catalog.stop_operation @operation_id = 199915
Hope it helps..
Alternate Keys which were introduced with CRM 2015 Update 1, gave us the ability to Upsert and Update records, by defining one or more fields as Alternate Key and use that field(s) instead of relying only on Primary Key.
Alternate Keys can also be used for setting or updating the lookup instead of GUID.
CDS\CRM Destination Component in KingswaySoft SSIS Integration Toolkit allows us the option of specifying the Alternate Key for updating the lookup field.
Suppose we have Contact entity with following Alternate Key defined in it
Within the CDS/CRM Destination Component Editor for the lookup field, click on ellipsis for the Text Lookup column. Here we have selected parent contact field inside Lead Entity.
Inside Text Lookup Editor, select the option “Choose Target Field(s)”, in lookup method select Alternate Key and we will see both our alternate keys listed there.
One thing I have observed that it doesn’t list the alternate key if it is defined by using more than 2 fields. Looks like it is by design.
Hope it helps..
Nishant Rana's Weblog 