"WFD" <anonymous@discussions.microsoft.com> wrote in message
news:1ce301c4271a$3ed4e870$a401280a@phx.gbl...
> 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

"WFD" <anonymous@discussions.microsoft.com> wrote in message
news:216201c42799$9c5767f0$a101280a@phx.gbl...
> 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
>
> >-----Original Message-----
> >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),
> > ...
> > ..
> > .
> > )
> >
> >If the destination is an incrementing value (IDENTITY())
> then no you do not
> >need to do anything in the source but be aware of
> loading the data
> >
> >Problems With IDENTITY() and the DataPump task.
> >(http://www.sqldts.com/default.aspx?293)
> >
> >--
> >
> >----------------------------
> >
> >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@discussions.microsoft.com> wrote in
> message
> >news:1ce301c4271a$3ed4e870$a401280a@phx.gbl...
> >> 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
> >
> >
> >.
> >