Populate Normalized Data!!!!

24 Mar 2006 3:53 PM

Vai2000

Hi All, I have a data file with delimiters that contains data for relational
table. How can I populate these tables with the data file without writing
much of code.
The trick is these tables have Constraints PK, FK and identity fields. The
ID From Table1 is the FK in Table2....
BCP with format file...any more tips???

TIA

24 Mar 2006 4:23 PM

JT

BCP into non-keyed staging tables. Once done, selecting into the production
tables is more simple.

Show quote

"Vai2000" <nospam@microsoft.com> wrote in message
news:ukvnRs1TGHA.4080@TK2MSFTNGP10.phx.gbl...
> Hi All, I have a data file with delimiters that contains data for
> relational
> table. How can I populate these tables with the data file without writing
> much of code.
> The trick is these tables have Constraints PK, FK and identity fields. The
> ID From Table1 is the FK in Table2....
> BCP with format file...any more tips???
>
> TIA
>
>

24 Mar 2006 6:38 PM

JDP@Work

2nd That, I always use staging tables, there has NEVER been a time that it
wasn't the right thing to do.

I even often opt for, C1 production ,C1_Stage ,C1_Load where load is a raw load
into tables that mirror the data file, stage that resembles my production table
but a last opportunity to have data errors w/out impacting live data in
transformations.

Then it's a simple copy from C1_Stage to production C1

Respect the Live Production Database, RLPD

HTH

JeffP....

Show quote

"JT" <some***@microsoft.com> wrote in message
news:%23e4J581TGHA.1572@tk2msftngp13.phx.gbl...
> BCP into non-keyed staging tables. Once done, selecting into the production
> tables is more simple.
>
> "Vai2000" <nospam@microsoft.com> wrote in message
> news:ukvnRs1TGHA.4080@TK2MSFTNGP10.phx.gbl...
> > Hi All, I have a data file with delimiters that contains data for
> > relational
> > table. How can I populate these tables with the data file without writing
> > much of code.
> > The trick is these tables have Constraints PK, FK and identity fields. The
> > ID From Table1 is the FK in Table2....
> > BCP with format file...any more tips???
> >
> > TIA