| Author |
Message |
Darryl Henderson
Guest
|
 Posted:
Fri Nov 11, 2005 1:03 am Post subject:
Data Migration w/DTS - EXT Files - What settings |
|
|
I'm doing a CRM data migration with the Data Migration Foundation (DMF) and
SQL Data Translation Services (DTS). Account and Contact only, but with many
custom fields. The DTS packages for Account and Contact work fine and with
fast load (property option) off create the triggers that create the ID's
(Account or Contact ID - plug number) -into the EXT files (for the custom
Account and Contact fields) but I can't get the DTS package right to load the
Common Data Format (CDF) _EXT tables over the trigger loaded ID data.
I can force the data in but the Migration procedure ignores them.
Any nobody know what the property settings should be for creation of the
main (Account) and custom (Account_Ext) table imports (DTS's)should be. Any
ideas?
--
Darryl - dh@mtccrm.com -www.mtccrm.com - Only Microsoft CRM
|
|
| Back to top |
|
 |
Bullitt Fitzhugh
Guest
|
| Posted:
Fri Nov 11, 2005 8:59 am Post subject:
RE: Data Migration w/DTS - EXT Files - What settings |
|
|
I have a different list of acronyms.
DMF- Data Migration Framework
DTS- Data Transformation Service
CDF- Comma Delimited Format
But that's ok.
The Data Migration Framework is just that- a framework. And believe me, we
have all been there. It can be very frustrating.
Have you meticulously run all of the stored procedures documented in the
Data Migration Framework guide? Particurlary Chapter 6, and the stuff about
drop-downs.
And have you unchecked the Fast Load box on the Options tab of your DTS job?
Those are the two issues that I have lost my hair over...
--
Bullitt Fitzhugh
Integrated Business Systems
www.ib-systems.com
"Darryl Henderson" wrote:
| Quote: | I'm doing a CRM data migration with the Data Migration Foundation (DMF) and
SQL Data Translation Services (DTS). Account and Contact only, but with many
custom fields. The DTS packages for Account and Contact work fine and with
fast load (property option) off create the triggers that create the ID's
(Account or Contact ID - plug number) -into the EXT files (for the custom
Account and Contact fields) but I can't get the DTS package right to load the
Common Data Format (CDF) _EXT tables over the trigger loaded ID data.
I can force the data in but the Migration procedure ignores them.
Any nobody know what the property settings should be for creation of the
main (Account) and custom (Account_Ext) table imports (DTS's)should be. Any
ideas?
--
Darryl - dh@mtccrm.com -www.mtccrm.com - Only Microsoft CRM |
|
|
| Back to top |
|
|
Jakob Benediktson
Guest
|
| Posted:
Fri Nov 11, 2005 5:02 pm Post subject:
RE: Data Migration w/DTS - EXT Files - What settings |
|
|
Hi
You should try ImportManager from www.crmextensions.com, it will save you
ALOT of time and frustration. Very easy to use, and very cheap ! Try it for
free for AWC
/Jakob
"Bullitt Fitzhugh" wrote:
| Quote: | I have a different list of acronyms.
DMF- Data Migration Framework
DTS- Data Transformation Service
CDF- Comma Delimited Format
But that's ok.
The Data Migration Framework is just that- a framework. And believe me, we
have all been there. It can be very frustrating.
Have you meticulously run all of the stored procedures documented in the
Data Migration Framework guide? Particurlary Chapter 6, and the stuff about
drop-downs.
And have you unchecked the Fast Load box on the Options tab of your DTS job?
Those are the two issues that I have lost my hair over...
--
Bullitt Fitzhugh
Integrated Business Systems
www.ib-systems.com
"Darryl Henderson" wrote:
I'm doing a CRM data migration with the Data Migration Foundation (DMF) and
SQL Data Translation Services (DTS). Account and Contact only, but with many
custom fields. The DTS packages for Account and Contact work fine and with
fast load (property option) off create the triggers that create the ID's
(Account or Contact ID - plug number) -into the EXT files (for the custom
Account and Contact fields) but I can't get the DTS package right to load the
Common Data Format (CDF) _EXT tables over the trigger loaded ID data.
I can force the data in but the Migration procedure ignores them.
Any nobody know what the property settings should be for creation of the
main (Account) and custom (Account_Ext) table imports (DTS's)should be. Any
ideas?
--
Darryl - dh@mtccrm.com -www.mtccrm.com - Only Microsoft CRM |
|
|
| Back to top |
|
|
Matt Parks
Guest
|
| Posted:
Sun Nov 13, 2005 1:01 am Post subject:
Re: Data Migration w/DTS - EXT Files - What settings |
|
|
How exactly are you rying to load the _Ext tables? By default, these
records are created by triggers on the main table. These record should then
either be deleted and then recreated by your own procedure or they should be
updated in place with appropriate values. The key is for the ID on the 2
tables to be the same.
--
Matt Parks
MVP - Microsoft CRM
"Darryl Henderson" <DarrylHenderson@discussions.microsoft.com> wrote in
message news:A4652136-689E-4CDC-AD5A-E322C329E18A@microsoft.com...
I'm doing a CRM data migration with the Data Migration Foundation (DMF) and
SQL Data Translation Services (DTS). Account and Contact only, but with many
custom fields. The DTS packages for Account and Contact work fine and with
fast load (property option) off create the triggers that create the ID's
(Account or Contact ID - plug number) -into the EXT files (for the custom
Account and Contact fields) but I can't get the DTS package right to load
the
Common Data Format (CDF) _EXT tables over the trigger loaded ID data.
I can force the data in but the Migration procedure ignores them.
Any nobody know what the property settings should be for creation of the
main (Account) and custom (Account_Ext) table imports (DTS's)should be. Any
ideas?
--
Darryl - dh@mtccrm.com -www.mtccrm.com - Only Microsoft CRM |
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in