Microsoft Office Document Imaging no longer in Printers Folder, Using XP and Office XP Professional

Scenario: I need to insert Data into Multiple SQL Tables with Keys…

TRANSACTION
___________
TID(PK)
DATE
TIME
SOURCE

AUDIT
_____
AUID(PK)
TID(FK)
FILENAME

 

EMPLOYEE
____
EID(PK)
TID(FK)
FNAME
LNAME

ADDRESS
________
AID(PK)
EID(FK)
ADDRESS
CITY
STATE
ZIP

PHONE
______
PID(PK)
EID(FK)
TYPE
CODE

 

I am using WCF-SQL Adapter i need insert the muliple records received from source in to SQL in a single transaction.

How is the foreign key relation handled with WCF-SQL.

I have created the Composite Operation schema. Can i achieve all this in single Map or please give suggestions ASAP.

Hi,Using WCF-SQL Adapter inserting multiple  records in single transaction, see discussion in this

If your target database is SQL 2008 I would use the multiple  tables passed into a single stored proc as discussed in this blog entry: