Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Biztalk
Biztalk General discussion about Biztalk server.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Biztalk section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
View Poll Results: Is this possible thru the combination of a Tbl Looping and Tbl extractor functoid?
Yes 0 0%
No 0 0%
Voters: 0. You may not vote on this poll

Old August 17th, 2010, 06:45 AM
Registered User
Join Date: Aug 2010
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Passing a hardcoded value and manipulating data before passing it to Database table

Guys, this is not a scenario from the BizTalk book, but one that I am in the process of integrating.

I have a scenario in which i get a pipe delimited flat file which I have to send to SQL. I have three columns viz. Description, Amount and Code in SQL. I have three important queries :

1. I have a few columns in the SQL table in which i need to pass on a hardcoded value and these columns have no corresponding fields in the flat file.Eg: If description of a column in the file is NET Sales, then Code is 40004.

2. I have a few columns in which i have to pass a specific value and these fields have got corresponding values in the flat file.Eg: If Net 2 Sales Quarter is the description in the file, then i need to pass it as Net Sales.

3. I need to add the Amount for certain values in the File and pass on the whole set of values in the file to a single row in SQL with the specific values:Eg: I have the flat file values as the values below and I need to add the two amounts and pass a specific description and the code a specific value as usual to the database table:

Description Amount

Net Sales $500

ManagerSalary $30000

The SQL table data for the above data would be:

Description Amount Code
Total Sales $30500 98098

Looking forward to your help at the earliest.

Last edited by Abhishek Iyer; August 18th, 2010 at 05:12 AM..

Similar Threads
Thread Thread Starter Forum Replies Last Post
passing data annumol J2EE 1 June 25th, 2009 06:03 AM
Passing table name as parameter in a DTS Package nimma SQL Server DTS 2 January 7th, 2005 02:24 AM
passing data texasraven HTML Code Clinic 0 March 3rd, 2004 05:03 PM
Manipulating data in a database - page 396 problem Jams30 BOOK: Beginning PHP4/PHP 5 ISBN: 978-0-7645-4364-7; v5 ISBN: 978-0-7645-5783-5 1 October 17th, 2003 03:13 PM
passing table as a parameter to stored procedure pankaj_daga SQL Server 2000 7 September 30th, 2003 05:11 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.