- This topic has 1 reply, 1 voice, and was last updated 9 years, 6 months ago by
.
-
Posts
-
-
What is the best method to move records into a SQL Server database. I will want to insert into multiple related tables. For example, Customer and Address. What is the best method to bring data from flat file to database tables using BizTalk. Is it a stored procedure with a bunch of params? Is it updategram? Is it BulkCopy via .net code call to load XML?
I am a SSIS/DTS person by nature, but in the attempt to maintian one point of interaction (BizTalk) I am curious about best method to bring data in from flat file to database.
Thanks.
-
I prefer stored procedures over updategrams. With a stored procedure you can do more complex operations without round trips between biztalk and the database. example:
IF EXISTS (Select * from employee where employeeid = @employeeID)
BEGIN
'Update record
END
ELSE
BEGIN
'Insert record
END
What are others thoughts on this?
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.