tag
This script will find custom Parental or Cascading Relationship between entities in CRM. This script was used to determine if someone had changed a relationship on a target system and if that change…
Update Rollup 17 for CRM 2011 creates new indexes for database tables when installed. Because of this the install can take several hours.
After generating a flat file in SSIS I needed to update that file with the column headers as the first row. In order to do this I used a SQL stored procedure.
You can use the commands below to create SQL commands which will drop tables/views. the were clause can be used to limit which tables/views are included in the statement.
This function will remove all non-alphanumeric characters.
This function will attempt to remove line breaks from text in SQL.
This script will give you the times for CRM import jobs that have been run on your system.
SSIS can sometimes take a long time to load. Try messing witht he DefaultBufferMaxRows setting in the package.
Disable Loopback check HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control/Lsa New DWORD Value: DisableLoopbackCheck = 1 (Decimal) CRM Settings HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/MSCRM New DWORD…
Here are two scripts I found that will help you generate basic info about your database. This data can be useful when beginning the level of effort for a data migration. NUMBER OF COLUMNS PER TABLE
Re-index your CRM Org database if you receive this error.
So here was my issue. I needed to copy some from one row in a table to another row. I tried using the SQL Server Managment Studio but it does not allow you to copy and past binary information.
Here are some SSIS devlopment tips and tricks.
