I am trying to import a table into a cdf database to get
it from Goldmine into MS CRM. There is a "ContactID" (int-
pk4) field that evidently is the key in the cdf file but
there is no matching field in the source data.
Do I have to somehow create a new column in the source
data in order to process the data? If not, how do I get
around this issue? Thanks in advance for your help.

Lost in Translation

You have a couple of options

Is the "ContactID" attribute an incrementing integer? Does it have the
IDENTITY() property?
If not then you will have to find a way of attributing a value to the
Destination that will uniquely identify the source. How do you identify the
Source row currently?

This raises a problem in that if you add your own key value generated from
however you wish then you will, IMHO, need to be able to tie the two
together so that anyone looking at the Destination can see from where the
row came in the Source. I do this with some of my dataloads as well so my
destination may look like

CREATE TABLE DestTable
(
ProductID int Primary Key,
SourceProductID varchar(10),
...
..

The "ContactID" is a string and the destination ID is an
integer. There are no integer values in the source data
to match to the destination.

Thanks

If there is no IDENTITY() property to the destination ID attribute and the
Source ContactID is a string and does not contain integer data then you are
going to have to generate your own ID values.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"WFD" <anonymous (AT) discussions (DOT) microsoft.com> wrote