"snbat" <snbat@aew_nospam.com> wrote in message
news:eq5VWVowEHA.908@TK2MSFTNGP11.phx.gbl...
> Hi ,
>
> I am new to using sqlbulkloader.
>
> I am trying to use sqlbulkloader to insert xml data into 5 tables. Three
> of which refer to lookup tables which do not belong to the 5 tables I am
> trying to insert into.
>
> My question is, is there a way to get the looup data(column) while
> inserting records into a table using SQLXMLBulkLoader ?
>
> For example, A,B,D,C are my insert tables and E is lookUp table for C.
>
> So when I am inserting records into C , I should look up in E and get a
> Column value to be inserted in C along with other columns from xml file. A
> and C are Parent and Child tables respectively.
>
> I greatly appreciate any help in this.
>
> Thank You.
>
> User submitted from AEWNET (http://www.aewnet.com/)